| 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
| 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) |