Re: [GENERAL] creating "a perfect sequence" column

2008-07-07 Thread Jack Brown
> On Sun, Jul 6, 2008 at 7:33 PM, Berend Tober wrote: > > This question comes up a lot. A term used in prior > discussions is "gapless > > sequence". > > > Thank you, i didn't know the term so when I'd searched the archives, i hadn't found much. > > What would be really more interesting for disc

[GENERAL] creating "a perfect sequence" column

2008-07-06 Thread Jack Brown
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. The