Setting up a cyclic sequence generator without holes - Mailing list pgsql-novice

From Leon Starr
Subject Setting up a cyclic sequence generator without holes
Date
Msg-id 1A6E2499-F525-415B-A658-997F6E96A173@modelint.com
Whole thread Raw
List pgsql-novice
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
wantthe sequence to start cycling through the holes (and pick 27 next, assuming there were no other de-allocations).  I
don'twant 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 by date:

Previous
From: Mike Thomsen
Date:
Subject: Some basic SSL configuration questions
Next
From: "Leon Match"
Date:
Subject: Job does not wok - How to test it?