Re: Missing sequences... how to retrieve the missing no?
From: Gennaro Napolitano <Gennaro.Napolitano_at_italdata.it>
Date: 2000/05/10
Message-ID: <39190A44.2C2FA60C_at_italdata.it>#1/1
Date: 2000/05/10
Message-ID: <39190A44.2C2FA60C_at_italdata.it>#1/1
Hello
I think that using "select max(id) +1 from table" still does not guarantee
contiguous
values for a column, furthermore you can generate duplicate values.
Ciao Gennaro
Mike Dwyer wrote:
> This should be in a FAQ.
>
> What you are asking to do should not be done with a sequence. Use select
> max(id) +1 from table. You really cannot guarantee contiguous
> (uninterrupted) values from a sequence.
Received on Wed May 10 2000 - 00:00:00 CEST