Neil Conway wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Neil Conway writes:
> > > Can you point me to where in the standard these are defined? (I looked
> > > briefly but couldn't find it.)
> >
> > The current value is set with ALTER SEQUENCE name RESTART WITH value;
> > (11.63).
>
> Great, thanks for the info.
>
> > "serial" columns are defined like
> >
> > foo int GENERATED BY DEFAULT AS IDENTITY [(sequence options)]
>
> Wow, that's verbose. I suppose it's still worth supporting, but you've
> got to wonder how the committee every arrived at that syntax...
>
> Since it seems the SQL 200x stuff has the same semantics as the
> sequences we already have, I think this patch is still suitable for
> application (I'll fix some more of the syntax stuff later, I'll
> definately have time before 7.4) -- Bruce, can you add this back to
> the queue for 7.4?
Sure, would you shoot it over to me again? Thanks.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073