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 discussion on

Re: [GENERAL] creating a perfect sequence column

2008-07-07 Thread Richard Broersma
On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown [EMAIL PROTECTED] wrote: Thank you, i didn't know the term so when I'd searched the archives, i hadn't found much. Here is the result of a discussion that came up a couple of years ago: http://www.varlena.com/GeneralBits/130.php I guess that german

Re: [GENERAL] creating a perfect sequence column

2008-07-07 Thread André Volpato
On Mon, Jul 7, 2008 at 4:54 AM, Jack Brown [EMAIL PROTECTED] wrote: Richard Broersma escreveu: in the mean time i did some research for other rdbms and i guess, what i was looking for was more along the lines of e.g. the row_number() function of mssql [1]. fwiw this seems like the most

Re: [GENERAL] creating a perfect sequence column

2008-07-07 Thread Scott Ribe
it's sort of a formal document management system. the assigned gapless numbers are frozen at the end of each month. until then, an authorized user will be able to delete a document. but ... Another way of dealing with this is to keep the association between the number and the document it was

[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.

Re: [GENERAL] creating a perfect sequence column

2008-07-06 Thread Scott Marlowe
On Sun, Jul 6, 2008 at 6:15 PM, Jack Brown [EMAIL PROTECTED] 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

Re: [GENERAL] creating a perfect sequence column

2008-07-06 Thread Berend Tober
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

Re: [GENERAL] creating a perfect sequence column

2008-07-06 Thread Scott Marlowe
On Sun, Jul 6, 2008 at 7:33 PM, Berend Tober [EMAIL PROTECTED] wrote: 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