Re: tweak CREATE SEQUENCE grammar

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: tweak CREATE SEQUENCE grammar
Date: 2002-10-01 20:03:23
Message-ID: Pine.LNX.4.44.0210012018470.1149-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Neil Conway writes:

> > [spec defines different syntax to ] set the current value, define
> > "serial" columns
>
> 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). "serial" columns are defined like

foo int GENERATED BY DEFAULT AS IDENTITY [(sequence options)]

(11.4).

> This passage suggests to me that sequences can contain holes (4.22,
> p.71):

You're right.

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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Alexey Borzov 2002-10-02 09:44:16 another attempt at fixing contrib/rserv...
Previous Message Bruce Momjian 2002-10-01 15:15:52 another attempt at patching contrib/rserv/Makefile (fwd)