summaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2007-02-03 17:59:36 +0000
committerPeter Eisentraut <peter_e@gmx.net>2007-02-03 17:59:36 +0000
commit4c488e857eca84948d0d3057ec87296f92bce944 (patch)
tree62c1ebb8f4f8ffd67a6b4856be2e0c92d1c38713 /doc/src
parentec020e1ceb94d0ceb3c0eee8c39cd197be7bb3cb (diff)
Update SQL conformance information about XML features.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/features.sgml40
1 files changed, 21 insertions, 19 deletions
diff --git a/doc/src/sgml/features.sgml b/doc/src/sgml/features.sgml
index 26979adf525..eae4ba5a11b 100644
--- a/doc/src/sgml/features.sgml
+++ b/doc/src/sgml/features.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/features.sgml,v 2.26 2007/01/31 20:56:17 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/features.sgml,v 2.27 2007/02/03 17:59:35 petere Exp $ -->
<appendix id="features">
<title>SQL Conformance</title>
@@ -14,19 +14,21 @@
<para>
The formal name of the SQL standard is ISO/IEC 9075 <quote>Database
Language SQL</quote>. A revised version of the standard is released
- from time to time; the most recent one appearing in late 2003. That
- version is referred to as ISO/IEC 9075:2003, or simply as SQL:2003.
- The versions prior to that were SQL:1999 and SQL-92. Each version
+ from time to time; the most recent full update appearing in 2003,
+ with a partial update appearing in 2006. The 2003 version is
+ referred to as ISO/IEC 9075:2003, or simply as SQL:2003. The
+ versions prior to that were SQL:1999 and SQL-92. Each version
replaces the previous one, so claims of conformance to earlier
versions have no official merit.
<productname>PostgreSQL</productname> development aims for
conformance with the latest official version of the standard where
such conformance does not contradict traditional features or common
- sense. The PostgreSQL project was not represented in the ISO/IEC
- 9075 Working Group during the preparation of SQL:2003. Even so,
- many of the features required by SQL:2003 are already supported,
- though sometimes with slightly differing syntax or function.
- Further moves towards conformance should be expected in later releases.
+ sense. The PostgreSQL project is not represented in the ISO/IEC
+ 9075 Working Group during the preparation of the SQL standard
+ releases, but even so, many of the features required by the SQL
+ standard are supported, though sometimes with slightly differing
+ syntax or function. Further moves towards conformance can be
+ expected over time.
</para>
<para>
@@ -56,20 +58,20 @@
are not consecutively numbered.
<itemizedlist>
- <listitem><para>ISO/IEC 9075-1 Framework (<acronym>SQL/Framework</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-2 Foundation (<acronym>SQL/Foundation</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-3 Call Level Interface (<acronym>SQL/CLI</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-4 Persistent Stored Modules (<acronym>SQL/PSM</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-9 Management of External Data (<acronym>SQL/MED</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-10 Object Language Bindings (<acronym>SQL/OLB</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-11 Information and Definition Schemas (<acronym>SQL/Schemata</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-13 Routines and Types using the Java Language (<acronym>SQL/JRT</acronym>)</para></listitem>
- <listitem><para>ISO/IEC 9075-14 XML-related specifications (<acronym>SQL/XML</acronym>)</para></listitem>
+ <listitem><para>ISO/IEC 9075-1 Framework (SQL/Framework)</para></listitem>
+ <listitem><para>ISO/IEC 9075-2 Foundation (SQL/Foundation)</para></listitem>
+ <listitem><para>ISO/IEC 9075-3 Call Level Interface (SQL/CLI)</para></listitem>
+ <listitem><para>ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM)</para></listitem>
+ <listitem><para>ISO/IEC 9075-9 Management of External Data (SQL/MED)</para></listitem>
+ <listitem><para>ISO/IEC 9075-10 Object Language Bindings (SQL/OLB)</para></listitem>
+ <listitem><para>ISO/IEC 9075-11 Information and Definition Schemas (SQL/Schemata)</para></listitem>
+ <listitem><para>ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT)</para></listitem>
+ <listitem><para>ISO/IEC 9075-14 XML-related specifications (SQL/XML)</para></listitem>
</itemizedlist>
</para>
<para>
- <productname>PostgreSQL</productname> covers parts 1, 2, and 11.
+ <productname>PostgreSQL</productname> covers parts 1, 2, 11, and 14.
Part 3 is similar to the ODBC interface, and part 4 is similar to
the <application>PL/pgSQL</application> programming language, but
exact conformance is not specifically intended or verified in either