Skip to content

Commit c3f1b0f

Browse files
author
Neil Conway
committed
This doc patch replaces all inappropriate references to SQL:1999 when it
is used as if it were the latest (and/or still valid) SQL standard. SQL:2003 is used in its place. Patch from Simon Riggs.
1 parent 2909419 commit c3f1b0f

13 files changed

+39
-41
lines changed

‎doc/src/sgml/array.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.43 2005/02/06 20:59:30 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.44 2005/07/14 06:17:35 neilc Exp $ -->
22

33
<sect1 id="arrays">
44
<title>Arrays</title>
@@ -63,7 +63,7 @@ CREATE TABLE tictactoe (
6363
</para>
6464

6565
<para>
66-
An alternative syntax, which conforms to the SQL:1999 standard, may
66+
An alternative syntax, which conforms to the SQL:2003 standard, may
6767
be used for one-dimensional arrays.
6868
<structfield>pay_by_quarter</structfield> could have been defined
6969
as:

‎doc/src/sgml/ddl.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.41 2005/06/13 02:40:01 neilc Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.42 2005/07/14 06:17:35 neilc Exp $ -->
22

33
<chapter id="ddl">
44
<title>Data Definition</title>
@@ -1122,7 +1122,7 @@ SELECT name, altitude
11221122
<para>
11231123
In previous versions of <productname>PostgreSQL</productname>, the
11241124
default behavior was not to include child tables in queries. This was
1125-
found to be error prone and is also in violation of the SQL:1999
1125+
found to be error prone and is also in violation of the SQL:2003
11261126
standard. Under the old syntax, to get the sub-tables you append
11271127
<literal>*</literal> to the table name.
11281128
For example

‎doc/src/sgml/ecpg.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ecpg.sgml,v 1.64 2005/05/20 12:36:48 neilc Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ecpg.sgml,v 1.65 2005/07/14 06:17:35 neilc Exp $
33
-->
44

55
<chapter id="ecpg">
@@ -1146,8 +1146,8 @@ struct
11461146
The fields <literal>sqlca.sqlstate</literal> and
11471147
<literal>sqlca.sqlcode</literal> are two different schemes that
11481148
provide error codes. Both are specified in the SQL standard, but
1149-
<literal>SQLCODE</literal> has been marked deprecated in the 1992
1150-
edition of the standard and has been dropped in the 1999 edition.
1149+
<literal>SQLCODE</literal> has been marked deprecated in SQL-92
1150+
edition of the standard and has been dropped in later editions.
11511151
Therefore, new applications are strongly encouraged to use
11521152
<literal>SQLSTATE</literal>.
11531153
</para>

‎doc/src/sgml/errcodes.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/errcodes.sgml,v 1.13 2005/06/26 19:16:04 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/errcodes.sgml,v 1.14 2005/07/14 06:17:35 neilc Exp $ -->
22

33
<appendix id="errcodes-appendix">
44
<title><productname>PostgreSQL</productname> Error Codes</title>
@@ -127,7 +127,7 @@
127127

128128
<row>
129129
<entry>Class 02</entry>
130-
<entry>No Data &mdash; this is also a warning class per SQL:1999</entry>
130+
<entry>No Data &mdash; this is also a warning class per SQL:2003</entry>
131131
</row>
132132

133133
<row>

‎doc/src/sgml/func.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.264 2005/07/10 04:54:30 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.265 2005/07/14 06:17:35 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -2543,8 +2543,8 @@ cast(-44 as bit(12)) <lineannotation>111111010100</lineannotation>
25432543
There are three separate approaches to pattern matching provided
25442544
by <productname>PostgreSQL</productname>: the traditional
25452545
<acronym>SQL</acronym> <function>LIKE</function> operator, the
2546-
more recent <function>SIMILAR TO</function> operator (added in
2547-
SQL:1999), and <acronym>POSIX</acronym>-style regular expressions.
2546+
more recent <function>SIMILAR TO</function> operator (part of
2547+
SQL:2003), and <acronym>POSIX</acronym>-style regular expressions.
25482548
Additionally, a pattern matching function,
25492549
<function>substring</function>, is available, using either
25502550
<function>SIMILAR TO</function>-style or POSIX-style regular

‎doc/src/sgml/ref/alter_domain.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_domain.sgml,v 1.15 2005/05/31 14:48:47 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_domain.sgml,v 1.16 2005/07/14 06:17:36 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -203,7 +203,7 @@ ALTER DOMAIN zipcode DROP CONSTRAINT zipchk;
203203
<title>Compatibility</title>
204204

205205
<para>
206-
The <command>ALTER DOMAIN</command> statement is compatible with SQL:1999,
206+
The <command>ALTER DOMAIN</command> statement is compatible with SQL:2003,
207207
except for the <literal>OWNER</> variant, which is a
208208
<productname>PostgreSQL</productname> extension.
209209
</para>

‎doc/src/sgml/ref/create_cast.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/create_cast.sgml,v 1.20 2004/12/13 18:05:10 petere Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/create_cast.sgml,v 1.21 2005/07/14 06:17:36 neilc Exp $ -->
22

33
<refentry id="SQL-CREATECAST">
44
<refmeta>
@@ -298,8 +298,8 @@ CREATE CAST (text AS int4) WITH FUNCTION int4(text);
298298
<title>Compatibility</title>
299299

300300
<para>
301-
The <command>CREATE CAST</command> command conforms to SQL:1999,
302-
except that SQL:1999 does not make provisions for binary-compatible
301+
The <command>CREATE CAST</command> command conforms to SQL:2003,
302+
except that SQL:2003 does not make provisions for binary-compatible
303303
types or extra arguments to implementation functions.
304304
<literal>AS IMPLICIT</> is a <productname>PostgreSQL</productname>
305305
extension, too.

‎doc/src/sgml/ref/create_function.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.65 2005/03/31 22:45:59 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_function.sgml,v 1.66 2005/07/14 06:17:36 neilc Exp $
33
-->
44

55
<refentry id="SQL-CREATEFUNCTION">
@@ -478,7 +478,7 @@ SELECT * FROM dup(42);
478478
<title>Compatibility</title>
479479

480480
<para>
481-
A <command>CREATE FUNCTION</command> command is defined in SQL:1999 and later.
481+
A <command>CREATE FUNCTION</command> command is defined in SQL:2003.
482482
The <productname>PostgreSQL</productname> version is similar but
483483
not fully compatible. The attributes are not portable, neither are the
484484
different available languages.

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.92 2005/02/02 06:35:59 neilc Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.93 2005/07/14 06:17:36 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -860,7 +860,7 @@ CREATE TABLE cinemas (
860860

861861
<para>
862862
The <command>CREATE TABLE</command> command conforms to SQL-92 and
863-
to a subset of SQL:1999, with exceptions listed below.
863+
to a subset of SQL:2003, with exceptions listed below.
864864
</para>
865865

866866
<refsect2>
@@ -938,8 +938,8 @@ CREATE TABLE cinemas (
938938
<para>
939939
Multiple inheritance via the <literal>INHERITS</literal> clause is
940940
a <productname>PostgreSQL</productname> language extension.
941-
SQL:1999 (but not SQL-92) defines single inheritance using a
942-
different syntax and different semantics. SQL:1999-style
941+
SQL:2003 defines single inheritance using a
942+
different syntax and different semantics. SQL:2003-style
943943
inheritance is not yet supported by
944944
<productname>PostgreSQL</productname>.
945945
</para>

‎doc/src/sgml/ref/create_trigger.sgml

Lines changed: 6 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/create_trigger.sgml,v 1.40 2004/11/27 21:27:07 petere Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_trigger.sgml,v 1.41 2005/07/14 06:17:36 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -208,20 +208,19 @@ CREATE TRIGGER <replaceable class="PARAMETER">name</replaceable> { BEFORE | AFTE
208208
<para>
209209
The <command>CREATE TRIGGER</command> statement in
210210
<productname>PostgreSQL</productname> implements a subset of the
211-
SQL:1999 standard. (There are no provisions for triggers in SQL-92.)
212-
The following functionality is missing:
211+
SQL:2003 standard. The following functionality is currently missing:
213212

214213
<itemizedlist>
215214
<listitem>
216215
<para>
217-
SQL:1999 allows triggers to fire on updates to specific columns
216+
SQL:2003 allows triggers to fire on updates to specific columns
218217
(e.g., <literal>AFTER UPDATE OF col1, col2</literal>).
219218
</para>
220219
</listitem>
221220

222221
<listitem>
223222
<para>
224-
SQL:1999 allows you to define aliases for the <quote>old</quote>
223+
SQL:2003 allows you to define aliases for the <quote>old</quote>
225224
and <quote>new</quote> rows or tables for use in the definition
226225
of the triggered action (e.g., <literal>CREATE TRIGGER ... ON
227226
tablename REFERENCING OLD ROW AS somename NEW ROW AS othername
@@ -235,7 +234,7 @@ CREATE TRIGGER <replaceable class="PARAMETER">name</replaceable> { BEFORE | AFTE
235234
<listitem>
236235
<para>
237236
<productname>PostgreSQL</productname> only allows the execution
238-
of a user-defined function for the triggered action. SQL:1999
237+
of a user-defined function for the triggered action. SQL:2003
239238
allows the execution of a number of other SQL commands, such as
240239
<command>CREATE TABLE</command> as triggered action. This
241240
limitation is not hard to work around by creating a user-defined
@@ -246,7 +245,7 @@ CREATE TRIGGER <replaceable class="PARAMETER">name</replaceable> { BEFORE | AFTE
246245
</para>
247246

248247
<para>
249-
SQL:1999 specifies that multiple triggers should be fired in
248+
SQL:2003 specifies that multiple triggers should be fired in
250249
time-of-creation order. <productname>PostgreSQL</productname> uses
251250
name order, which was judged more convenient to work with.
252251
</para>

0 commit comments

Comments
 (0)