Re: tweak CREATE SEQUENCE grammar - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: tweak CREATE SEQUENCE grammar
Date
Msg-id 200209290537.g8T5bch04373@candle.pha.pa.us
Whole thread Raw
In response to tweak CREATE SEQUENCE grammar  (Neil Conway <neilc@samurai.com>)
List pgsql-patches
This has been saved for the 7.4 release:

    http://candle.pha.pa.us/cgi-bin/pgpatches2

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

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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: additional patch for contrib/tablefunc - added to regression
Next
From: Bruce Momjian
Date:
Subject: Re: CLUSTER ALL patch