On Mon, Dec 13, 2004 at 19:37:41 +0100, Janning Vygen <[EMAIL PROTECTED]> wrote: > > the other reason why i wanted gapless sequences was that i would love to use > the id in an URL. But this is easy to manage to translate a positional id in > an URL to the database id.
For this you probably shouldn't be using the sort value (even if you use numeric to avoid having to renumber). This should use a real primary key. This you definitely can use a sequence for if there isn't a natural primary key. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])