On Sun, 2003-05-25 at 00:34, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> writes:
> > We need to track sequence usage in things like defaults. nextval()
> > function calls don't easily allow this to happen.
>
> Yeah. The Oracle syntax is seqname.nextval(); AFAIK our syntax
> nextval('seqname') was a quick-and-dirty approximation to that.
I doubt it'll be switched to the Oracle syntax. Most of the new
IDENTITY stuff seems to be based on MSSQL. Some of it is quite nice.
Sequences based on things other than integers would be useful (time
based with an interval incremental).
Perhaps we should just wait it out to see what actually comes through.
Feel free to file your thoughts on NEXT VALUE FOR though! I think there
was someone reading this list that was on the spec team at one point.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc