Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group