Re: Function PostgreSQL 9.2

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



    On 4/20/2016 3:33 PM,
      drum.lucas@xxxxxxxxx wrote:

    
      The customer can add any value into users.code:
      

      code
        CHARACTER VARYING,
      

    what if he puts in a non-unique value ?

    
      But he also can let it blank/null if he wants to.
      That's when the trigger do its job.. Put a value (starting in
        1000) in that column.
      

      Of course that has to be unique, as nobody can use the same
        value of others.
      

    thats really hard to do correctly under a concurrent workload

    
      - I was hoping you cans could help me to start doing the
        function...
    
    
    -- 
john r pierce, recycling bits in santa cruz