Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitc3f1b0f

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 parent2909419 commitc3f1b0f

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 inthe 1992
1150-
edition of the standard and has been dropped inthe 1999 edition.
1149+
<literal>SQLCODE</literal> has been marked deprecated inSQL-92
1150+
edition of the standard and has been dropped inlater 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>

‎doc/src/sgml/ref/create_type.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_type.sgml,v 1.56 2005/07/10 21:13:57 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/create_type.sgml,v 1.57 2005/07/14 06:17:36 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -533,7 +533,7 @@ CREATE TABLE big_objs (
533533
<para>
534534
This <command>CREATE TYPE</command> command is a
535535
<productname>PostgreSQL</productname> extension. There is a
536-
<command>CREATE TYPE</command> statement in SQL:1999 and later that is rather
536+
<command>CREATE TYPE</command> statement in SQL:2003 that is rather
537537
different in detail.
538538
</para>
539539
</refsect1>

‎doc/src/sgml/ref/select.sgml

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.87 2005/05/08 03:08:05 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.88 2005/07/14 06:17:36 neilc Exp $
33
PostgreSQL documentation
44
-->
55

@@ -1082,7 +1082,7 @@ SELECT distributors.* WHERE distributors.name = 'Westward';
10821082
<title>Namespace Available to <literal>GROUP BY</literal> and <literal>ORDER BY</literal></title>
10831083

10841084
<para>
1085-
In the SQL-92 standard, an <literal>ORDER BY</literal> clause may
1085+
In the SQL:2003 standard, an <literal>ORDER BY</literal> clause may
10861086
only use result column names or numbers, while a <literal>GROUP
10871087
BY</literal> clause may only use expressions based on input column
10881088
names. <productname>PostgreSQL</productname> extends each of
@@ -1095,11 +1095,11 @@ SELECT distributors.* WHERE distributors.name = 'Westward';
10951095
</para>
10961096

10971097
<para>
1098-
SQL:1999 uses a slightly different definition which is not entirely upward
1099-
compatible
1100-
with SQL-92.In most cases, however, <productname>PostgreSQL</productname>
1098+
SQL:2003 uses a slightly different definition which is not entirely upward
1099+
compatiblewith SQL-92.
1100+
In most cases, however, <productname>PostgreSQL</productname>
11011101
will interpret an <literal>ORDER BY</literal> or <literal>GROUP
1102-
BY</literal> expression the same way SQL:1999 does.
1102+
BY</literal> expression the same way SQL:2003 does.
11031103
</para>
11041104
</refsect2>
11051105

‎doc/src/sgml/sql.sgml

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/sql.sgml,v 1.36 2005/04/28 21:47:09 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/sql.sgml,v 1.37 2005/07/14 06:17:35 neilc Exp $
33
-->
44

55
<chapter id="sql-intro">
@@ -98,8 +98,7 @@ $PostgreSQL: pgsql/doc/src/sgml/sql.sgml,v 1.36 2005/04/28 21:47:09 tgl Exp $
9898
is under development. It is planned to make <acronym>SQL</acronym>
9999
a Turing-complete
100100
language, i.e. all computable queries (e.g. recursive queries) will be
101-
possible. This is a very complex task and therefore the completion of
102-
the new standard can not be expected before 1999.
101+
possible. This has now been completed as SQL:2003.
103102
</para>
104103

105104
<sect1 id="rel-model">

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp