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: 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 (view raw, whole thread or download thread mbox)
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)]


> 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


pgsql-patches by date

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

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