Re: tweak CREATE SEQUENCE grammar

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: tweak CREATE SEQUENCE grammar
Date: 2002-10-07 19:24:14
Message-ID: Pine.LNX.4.44.0210072112060.928-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Neil Conway writes:

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

The above line is just one example. Some of the key words can be changed
to get different behavior. All together, it acts as a replacement of the
DEFAULT clause.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2002-10-07 21:15:34 inline newNode()
Previous Message Tom Lane 2002-10-07 14:13:10 Re: Suggested change to pgbench