Re: tweak CREATE SEQUENCE grammar

Peter Eisentraut <peter_e(at)gmx(dot)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?

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC