Sequence Numbers
Date: 1995/04/03
Message-ID: <3lpa1l$n17_at_watnews1.watson.ibm.com>#1/1
As long as we are discussing sequence numbers, does anyone have an answer to
this question:
How can you get a sequence that never issues a number that is already in
use in a table?
Sequence numbers are obviously most useful for creating unique numbers that
can be used as keys. The problem is, you run out of numbers at some point
(before infinity), so the sequence must cycle. Now, if you are using the
Any one have a better way? I just can't believe that there is no reliable mechanism for generating primary key values.
Stan Received on Mon Apr 03 1995 - 00:00:00 CEST