Dear list,
I need some tips and/or pointers to relevant documentation implementing (what I chose to call) "a perfect sequence"
i.e.a sequence that has no missing numbers in the sequence. I'd like it to auto increment on insert, and auto decrement
everythingbigger than its value on delete. There are many mechanisms (rules, triggers, sequences, locks etc.) but I'm
notsure which combination would result in the most elegant implementation.
Oh, and if you know the right term for what I just described, I'd be more than pleased to hear it! :-)
All the best,
Jack