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

Commit0338169

Browse files
committed
Avoid referring to a specific version of the SQL standard except where
necessary, and be careful to refer to the right version where it isuseful to do so. This partially reverts an ill-considered search andreplace from a few months ago.
1 parent60945aa commit0338169

File tree

6 files changed

+18
-17
lines changed

6 files changed

+18
-17
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.44 2005/07/14 06:17:35 neilc Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.45 2005/11/04 02:56:30 tgl 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:2003 standard, may
66+
An alternative syntax, which conforms to the SQL 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: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.47 2005/11/03 00:51:43 neilc Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.48 2005/11/04 02:56:30 tgl Exp $ -->
22

33
<chapter id="ddl">
44
<title>Data Definition</title>
@@ -1058,8 +1058,8 @@ CREATE TABLE order_items (
10581058

10591059
<para>
10601060
<productname>PostgreSQL</productname> implements table inheritance
1061-
which can be a useful tool for database designers.TheSQL:2003
1062-
standard optionally defines type inheritance which differs in many
1061+
which can be a useful tool for database designers. SQL:1999 and
1062+
later define a type inheritance feature, which differs in many
10631063
respects from the features described here.
10641064
</para>
10651065

@@ -1323,7 +1323,7 @@ WHERE c.altitude &gt; 500 and c.tableoid = p.oid;
13231323
<para>
13241324
In previous versions of <productname>PostgreSQL</productname>, the
13251325
default behavior was not to include child tables in queries. This was
1326-
found to be error prone and is also in violation of the SQL:2003
1326+
found to be error prone and is also in violation of the SQL
13271327
standard. Under the old syntax, to get the sub-tables you append
13281328
<literal>*</literal> to the table name. For example:
13291329
<programlisting>
@@ -1364,7 +1364,7 @@ SELECT * from cities*;
13641364

13651365
<para>
13661366
Currently, partitioning is implemented in conjunction with table
1367-
inheritance only, though using fully SQL:2003 compliant syntax.
1367+
inheritance only, though using fully SQL compliant syntax.
13681368
Table inheritance allows tables to be split into partitions, and
13691369
constraint exclusion allows partitions to be selectively combined
13701370
as needed to satisfy a particular <command>SELECT</command>

‎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.69 2005/10/13 17:55:18 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ecpg.sgml,v 1.70 2005/11/04 02:56:30 tgl Exp $
33
-->
44

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

‎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.14 2005/07/14 06:17:35 neilc Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/errcodes.sgml,v 1.15 2005/11/04 02:56:30 tgl 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:2003</entry>
130+
<entry>No Data &mdash; this is also a warning class pertheSQL standard</entry>
131131
</row>
132132

133133
<row>

‎doc/src/sgml/func.sgml‎

Lines changed: 4 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.289 2005/10/25 15:47:51 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.290 2005/11/04 02:56:30 tgl Exp $
33
PostgreSQL documentation
44
-->
55

@@ -2675,8 +2675,9 @@ cast(-44 as bit(12)) <lineannotation>111111010100</lineannotation>
26752675
There are three separate approaches to pattern matching provided
26762676
by <productname>PostgreSQL</productname>: the traditional
26772677
<acronym>SQL</acronym> <function>LIKE</function> operator, the
2678-
more recent <function>SIMILAR TO</function> operator (part of
2679-
SQL:2003), and <acronym>POSIX</acronym>-style regular expressions.
2678+
more recent <function>SIMILAR TO</function> operator (added in
2679+
SQL:1999), and <acronym>POSIX</acronym>-style regular
2680+
expressions.
26802681
Additionally, a pattern matching function,
26812682
<function>substring</function>, is available, using either
26822683
<function>SIMILAR TO</function>-style or POSIX-style regular

‎doc/src/sgml/intro.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/intro.sgml,v 1.29 2005/04/09 03:52:43 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/intro.sgml,v 1.30 2005/11/04 02:56:31 tgl Exp $
33
-->
44

55
<preface id="preface">
@@ -98,7 +98,7 @@ $PostgreSQL: pgsql/doc/src/sgml/intro.sgml,v 1.29 2005/04/09 03:52:43 momjian Ex
9898

9999
<para>
100100
<productname>PostgreSQL</productname> is an open-source descendant
101-
of this original Berkeley code. It supports a large part of the SQL:2003
101+
of this original Berkeley code. It supports a large part of the SQL
102102
standard and offers many modern features:
103103

104104
<itemizedlist spacing="compact">

0 commit comments

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