aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2007-02-01 00:34:03 +0000
committerBruce Momjian <bruce@momjian.us>2007-02-01 00:34:03 +0000
commitb3687889c486d3a808cad0b46d6bf6c71d943d1c (patch)
tree584be5e0d569292766bb4280bd5b73e0f18b9f7b
parent40bf8717cf773f427b9aa182889dec4b74c11c9e (diff)
downloadpostgresql-b3687889c486d3a808cad0b46d6bf6c71d943d1c.tar.gz
postgresql-b3687889c486d3a808cad0b46d6bf6c71d943d1c.zip
Update CREATE SEQUENCE documentation to show the same sequence being
created and increments. The old docs created the sequence, then showed a nextval() of 114.
-rw-r--r--doc/src/sgml/ref/create_sequence.sgml15
1 files changed, 13 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml
index 61bee148bfa..e5afabf12ae 100644
--- a/doc/src/sgml/ref/create_sequence.sgml
+++ b/doc/src/sgml/ref/create_sequence.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.47 2007/02/01 00:28:18 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/create_sequence.sgml,v 1.48 2007/02/01 00:34:03 momjian Exp $
PostgreSQL documentation
-->
@@ -288,7 +288,18 @@ SELECT nextval('serial');
nextval
---------
- 114
+ 101
+</programlisting>
+ </para>
+
+ <para>
+ Select the next number from this sequence:
+<programlisting>
+SELECT nextval('serial');
+
+ nextval
+---------
+ 102
</programlisting>
</para>