Re: tweak CREATE SEQUENCE grammar

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