Re: tweak CREATE SEQUENCE grammar

Patch rejected.  Seems we need to address all the SQL standards changes
in this area in one patch.

---------------------------------------------------------------------------

Neil Conway wrote:
> This patch makes a few minor changes to the parsing of CREATE SEQUENCE
> to allow for some syntax variations consistent with SQL 2002 (or
> whatever the official name of the current draft standard will be),
> section 11.62:
>
>         START -> START [ WITH ]
>         INCREMENT -> INCREMENT [ BY ]
>         CYCLE -> [ NO ] CYCLE
>
> Should this new syntax be the default? Being standards-compliant is
> nice, and IMHO, the new syntax is nicer, anyway. But I'm not too
> worried about that, and I haven't encouraged the new syntax in the
> documentation.
>
> BTW, there are a few other small changes needed, as well as the
> addition of ALTER SEQUENCE, but other than that the new "sequence
> generator" feature of the standard is almost exactly what we've always
> implemented, AFAICT.
>
> This should be saved for 7.4, please.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  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