Jack Brown wrote:
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 everything bigger
than its value on delete. There are many mechanisms (rules, triggers, sequences, locks
etc.) but I'm not sure 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! :-)
This question comes up a lot. A term used in prior discussions is
"gapless sequence".
What would be really more interesting for discussion on this
community forum is a detailed description or your actual use case
and requirements.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
