From 03381695c61f2dc161b69d59914fed77d3d40e42 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 4 Nov 2005 02:56:31 +0000 Subject: [PATCH] Avoid referring to a specific version of the SQL standard except where necessary, and be careful to refer to the right version where it is useful to do so. This partially reverts an ill-considered search and replace from a few months ago. --- doc/src/sgml/array.sgml | 4 ++-- doc/src/sgml/ddl.sgml | 10 +++++----- doc/src/sgml/ecpg.sgml | 6 +++--- doc/src/sgml/errcodes.sgml | 4 ++-- doc/src/sgml/func.sgml | 7 ++++--- doc/src/sgml/intro.sgml | 4 ++-- 6 files changed, 18 insertions(+), 17 deletions(-) diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml index 7c89a7921c..4b03e18903 100644 --- a/doc/src/sgml/array.sgml +++ b/doc/src/sgml/array.sgml @@ -1,4 +1,4 @@ - + Arrays @@ -63,7 +63,7 @@ CREATE TABLE tictactoe ( - An alternative syntax, which conforms to the SQL:2003 standard, may + An alternative syntax, which conforms to the SQL standard, may be used for one-dimensional arrays. pay_by_quarter could have been defined as: diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 757e5d6183..0461c8b8b2 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1,4 +1,4 @@ - + Data Definition @@ -1058,8 +1058,8 @@ CREATE TABLE order_items ( PostgreSQL implements table inheritance - which can be a useful tool for database designers. The SQL:2003 - standard optionally defines type inheritance which differs in many + which can be a useful tool for database designers. SQL:1999 and + later define a type inheritance feature, which differs in many respects from the features described here. @@ -1323,7 +1323,7 @@ WHERE c.altitude > 500 and c.tableoid = p.oid; In previous versions of PostgreSQL, the default behavior was not to include child tables in queries. This was - found to be error prone and is also in violation of the SQL:2003 + found to be error prone and is also in violation of the SQL standard. Under the old syntax, to get the sub-tables you append * to the table name. For example: @@ -1364,7 +1364,7 @@ SELECT * from cities*; Currently, partitioning is implemented in conjunction with table - inheritance only, though using fully SQL:2003 compliant syntax. + inheritance only, though using fully SQL compliant syntax. Table inheritance allows tables to be split into partitions, and constraint exclusion allows partitions to be selectively combined as needed to satisfy a particular SELECT diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml index 10386a67fb..9b63153f9f 100644 --- a/doc/src/sgml/ecpg.sgml +++ b/doc/src/sgml/ecpg.sgml @@ -1,5 +1,5 @@ @@ -1145,8 +1145,8 @@ struct The fields sqlca.sqlstate and sqlca.sqlcode are two different schemes that - provide error codes. Both are specified in the SQL standard, but - SQLCODE has been marked deprecated in SQL-92 + provide error codes. Both are derived from the SQL standard, but + SQLCODE has been marked deprecated in the SQL-92 edition of the standard and has been dropped in later editions. Therefore, new applications are strongly encouraged to use SQLSTATE. diff --git a/doc/src/sgml/errcodes.sgml b/doc/src/sgml/errcodes.sgml index f099a06318..5f40fdd803 100644 --- a/doc/src/sgml/errcodes.sgml +++ b/doc/src/sgml/errcodes.sgml @@ -1,4 +1,4 @@ - + <productname>PostgreSQL</productname> Error Codes @@ -127,7 +127,7 @@ Class 02 -No Data — this is also a warning class per SQL:2003 +No Data — this is also a warning class per the SQL standard diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 5c3932dac9..15f3250518 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ @@ -2675,8 +2675,9 @@ cast(-44 as bit(12)) 111111010100 There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL LIKE operator, the - more recent SIMILAR TO operator (part of - SQL:2003), and POSIX-style regular expressions. + more recent SIMILAR TO operator (added in + SQL:1999), and POSIX-style regular + expressions. Additionally, a pattern matching function, substring, is available, using either SIMILAR TO-style or POSIX-style regular diff --git a/doc/src/sgml/intro.sgml b/doc/src/sgml/intro.sgml index 7f5ab401eb..37c1144aff 100644 --- a/doc/src/sgml/intro.sgml +++ b/doc/src/sgml/intro.sgml @@ -1,5 +1,5 @@ @@ -98,7 +98,7 @@ $PostgreSQL: pgsql/doc/src/sgml/intro.sgml,v 1.29 2005/04/09 03:52:43 momjian Ex PostgreSQL is an open-source descendant - of this original Berkeley code. It supports a large part of the SQL:2003 + of this original Berkeley code. It supports a large part of the SQL standard and offers many modern features: -- 2.40.0