Re: Function PostgreSQL 9.2

John R Pierce <pierce@xxxxxxxxxxxx> · Wed, 20 Apr 2016 15:05:17 -0700



    On 4/20/2016 2:51 PM,
      drum.lucas@xxxxxxxxx wrote:

    
      1 - The customer can add any value into users.code column
      2 - The customer can chose between add
            or not add
        the value on users.code column
      3 - If users.code is null (because the customer's chosen not
        to add any value in there), a trigger/function has to do the
        job.
      4 - the function/trigger add the next available value, which
        the default is 1000 and it's stored on
        companies.client_code_increment
    
    
    why don't you use a SEQUENCE for this?

    
        ... DEFAULT nextval('sequencename') ...

    
    initialize the sequence to 1000.

    
    done.

    
    still sounds pretty sketchy.

    
    -- 
john r pierce, recycling bits in santa cruz