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