Peter Eisentraut <peter_e@gmx.net> writes:
> It seems that the proposed standard's sequence generators have a
> number of syntactical and semantic differences from ours
Yeah, there are some differences, but overall I think the spec-defined
behavior is remarkably similar to what we currently implement.
> [spec defines different syntax to ] set the current value, define
> "serial" columns
Can you point me to where in the standard these are defined? (I looked
briefly but couldn't find it.)
> [SQL 200x] sequences are apparently not allowed to contain holes.
This passage suggests to me that sequences can contain holes (4.22,
p.71):
Changes to the current base value of a sequence generator are
not controlled by SQL-transactions; therefore, commits and
rollbacks of SQL-transactions have no effect on the base value
of a sequence generator.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC