From 4c488e857eca84948d0d3057ec87296f92bce944 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sat, 3 Feb 2007 17:59:36 +0000 Subject: Update SQL conformance information about XML features. --- doc/src/sgml/features.sgml | 40 +++++++++++++++++++++------------------- 1 file changed, 21 insertions(+), 19 deletions(-) (limited to 'doc') 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 @@ - + SQL Conformance @@ -14,19 +14,21 @@ The formal name of the SQL standard is ISO/IEC 9075 Database Language SQL. 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. PostgreSQL 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. @@ -56,20 +58,20 @@ are not consecutively numbered. - ISO/IEC 9075-1 Framework (SQL/Framework) - ISO/IEC 9075-2 Foundation (SQL/Foundation) - ISO/IEC 9075-3 Call Level Interface (SQL/CLI) - ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM) - ISO/IEC 9075-9 Management of External Data (SQL/MED) - ISO/IEC 9075-10 Object Language Bindings (SQL/OLB) - ISO/IEC 9075-11 Information and Definition Schemas (SQL/Schemata) - ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT) - ISO/IEC 9075-14 XML-related specifications (SQL/XML) + ISO/IEC 9075-1 Framework (SQL/Framework) + ISO/IEC 9075-2 Foundation (SQL/Foundation) + ISO/IEC 9075-3 Call Level Interface (SQL/CLI) + ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM) + ISO/IEC 9075-9 Management of External Data (SQL/MED) + ISO/IEC 9075-10 Object Language Bindings (SQL/OLB) + ISO/IEC 9075-11 Information and Definition Schemas (SQL/Schemata) + ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT) + ISO/IEC 9075-14 XML-related specifications (SQL/XML) - PostgreSQL covers parts 1, 2, and 11. + PostgreSQL covers parts 1, 2, 11, and 14. Part 3 is similar to the ODBC interface, and part 4 is similar to the PL/pgSQL programming language, but exact conformance is not specifically intended or verified in either -- cgit v1.2.3