From 3eabc4490ecbf6b9845917811cf930af41aff845 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 10 Nov 2002 00:10:20 +0000 Subject: Tweak CREATE SEQUENCE grammar to be more SQL1999 standards compliant. Neil Conway --- doc/src/sgml/ref/create_sequence.sgml | 25 ++++++++++++++++++------- 1 file changed, 18 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 3db79850c8a..4e36dfbe771 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -1,5 +1,5 @@ @@ -21,9 +21,9 @@ PostgreSQL documentation 1999-07-20 -CREATE [ TEMPORARY | TEMP ] SEQUENCE seqname [ INCREMENT increment ] +CREATE [ TEMPORARY | TEMP ] SEQUENCE seqname [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue ] [ MAXVALUE maxvalue ] - [ START start ] [ CACHE cache ] [ CYCLE ] + [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ] @@ -130,8 +130,8 @@ CREATE [ TEMPORARY | TEMP ] SEQUENCE seqnameCYCLE - The optional CYCLE keyword may be used to enable the sequence - to wrap around when the + The optional keyword may be used to enable + the sequence to wrap around when the maxvalue or minvalue has been reached by @@ -140,11 +140,22 @@ CREATE [ TEMPORARY | TEMP ] SEQUENCE seqnameminvalue or maxvalue, respectively. - Without CYCLE, after the limit is reached nextval calls - will return an error. + + + NO CYCLE + + + If the optional keyword is specified, any + calls to nextval after the sequence has reached + its maximum value will return an error. If neither + or are specified, + is the default. + + + -- cgit v1.2.3