Setting up a cyclic sequence generator without holes

Поиск
Список
Период
Сортировка
Искать
От
Leon Starr
Тема
Setting up a cyclic sequence generator without holes
Дата
Msg-id
1A6E2499-F525-415B-A658-997F6E96A173@modelint.com
Список
I am trying to set up a sequence that assigns values within a specific range, say 1-99.   But, for my particular application, I need the ability to de-allocate a number that was previously assigned, say 27.  Then, when we hit 99, I want the sequence to start cycling through the holes (and pick 27 next, assuming there were no other de-allocations).  I don't want the sequencer to simply cycle back through numbers already in use.

Has anyone else done this or know any tricks?  Otherwise, it looks like I will just have to make my own sequencer.  Thanks.

- Leon Starr
В списке pgsql-novice по дате отправления
От: Mike Thomsen
Дата:
От: Leon Match
Дата:
FAQ