On 4/20/2016 3:33 PM, drum(dot)lucas(at)gmail(dot)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