On 4/20/2016 3:33 PM, drum.lu...@gmail.com 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

Reply via email to