aboutsummaryrefslogtreecommitdiff
path: root/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 /src
parentec020e1ceb94d0ceb3c0eee8c39cd197be7bb3cb (diff)
downloadpostgresql-4c488e857eca84948d0d3057ec87296f92bce944.tar.gz
postgresql-4c488e857eca84948d0d3057ec87296f92bce944.zip
Update SQL conformance information about XML features.
Diffstat (limited to 'src')
-rw-r--r--src/backend/catalog/information_schema.sql14
-rw-r--r--src/backend/catalog/sql_features.txt55
2 files changed, 62 insertions, 7 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql
index a41801b5ac7..7401e21c074 100644
--- a/src/backend/catalog/information_schema.sql
+++ b/src/backend/catalog/information_schema.sql
@@ -4,7 +4,7 @@
*
* Copyright (c) 2003-2007, PostgreSQL Global Development Group
*
- * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.40 2007/01/16 18:32:26 tgl Exp $
+ * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.41 2007/02/03 17:59:35 petere Exp $
*/
/*
@@ -1615,12 +1615,12 @@ CREATE TABLE sql_parts (
INSERT INTO sql_parts VALUES ('1', 'Framework (SQL/Framework)', 'NO', NULL, '');
INSERT INTO sql_parts VALUES ('2', 'Foundation (SQL/Foundation)', 'NO', NULL, '');
INSERT INTO sql_parts VALUES ('3', 'Call-Level Interface (SQL/CLI)', 'NO', NULL, '');
-INSERT INTO sql_parts VALUES ('4', 'Persistent Stored Modules (SQL/PSM)', NULL, '');
-INSERT INTO sql_parts VALUES ('9', 'Management of External Data (SQL/MED)', NULL, '');
-INSERT INTO sql_parts VALUES ('10', 'Object Language Bindings (SQL/OLB)', NULL, '');
-INSERT INTO sql_parts VALUES ('11', 'Information and Definition Schema (SQL/Schemata)', NULL, '');
-INSERT INTO sql_parts VALUES ('13', 'Routines and Types Using the Java Programming Language (SQL/JRT)', NULL, '');
-INSERT INTO sql_parts VALUES ('14', 'XML-Related Specifications (SQL/XML)', NULL, '');
+INSERT INTO sql_parts VALUES ('4', 'Persistent Stored Modules (SQL/PSM)', 'NO', NULL, '');
+INSERT INTO sql_parts VALUES ('9', 'Management of External Data (SQL/MED)', 'NO', NULL, '');
+INSERT INTO sql_parts VALUES ('10', 'Object Language Bindings (SQL/OLB)', 'NO', NULL, '');
+INSERT INTO sql_parts VALUES ('11', 'Information and Definition Schema (SQL/Schemata)', 'NO', NULL, '');
+INSERT INTO sql_parts VALUES ('13', 'Routines and Types Using the Java Programming Language (SQL/JRT)', 'NO', NULL, '');
+INSERT INTO sql_parts VALUES ('14', 'XML-Related Specifications (SQL/XML)', 'YES', NULL, '');
/*
diff --git a/src/backend/catalog/sql_features.txt b/src/backend/catalog/sql_features.txt
index ab83fcc2fdf..5766049797d 100644
--- a/src/backend/catalog/sql_features.txt
+++ b/src/backend/catalog/sql_features.txt
@@ -437,3 +437,58 @@ T652 SQL-dynamic statements in SQL routines NO
T653 SQL-schema statements in external routines NO
T654 SQL-dynamic statements in external routines NO
T655 Cyclically dependent routines NO
+X010 XML type YES
+X011 Arrays of XML type YES
+X012 Multisets of XML type NO
+X013 Distinct types of XML type NO
+X014 Attributes of XML type NO
+X015 Fields of XML type NO
+X016 Persistent XML values YES
+X020 XML concatenation YES
+X031 XMLElement YES
+X032 XMLForest YES
+X033 XMLRoot YES
+X034 XMLAgg YES
+X035 XMLAgg: ORDER BY option NO
+X036 XMLComment YES
+X037 XMLPI YES
+X041 Basic table mapping: nulls absent NO
+X042 Basic table mapping: null as nil NO
+X043 Basic table mapping: table as forest NO
+X044 Basic table mapping: table as element NO
+X045 Basic table mapping: with target namespace NO
+X046 Basic table mapping: data mapping NO
+X047 Basic table mapping: metadata mapping NO
+X048 Basic table mapping: base64 encoding of binary strings NO
+X049 Basic table mapping: hex encoding of binary strings NO
+X051 Advanced table mapping: nulls absent NO
+X052 Advanced table mapping: null as nil NO
+X053 Advanced table mapping: table as forest NO
+X054 Advanced table mapping: table as element NO
+X055 Advanced table mapping: target namespace NO
+X056 Advanced table mapping: data mapping NO
+X057 Advanced table mapping: metadata mapping NO
+X058 Advanced table mapping: base64 encoding of binary strings NO
+X059 Advanced table mapping: hex encoding of binary strings NO
+X060 XMLParse: CONTENT option YES
+X061 XMLParse: DOCUMENT option YES
+X062 XMLParse: explicit WHITESPACE option YES
+X070 XMLSerialize: CONTENT option YES
+X071 XMLSerialize: DOCUMENT option YES
+X080 Namespaces in XML publishing NO
+X081 Query-level XML namespace declarations NO
+X082 XML namespace declarations in DML NO
+X083 XML namespace declarations in DDL NO
+X084 XML namespace declarations in compound statements NO
+X090 XML document predicate YES
+X100 Host language support for XML: CONTENT option NO
+X101 Host language support for XML: DOCUMENT option NO
+X110 Host language support for XML: VARCHAR mapping NO
+X111 Host language support for XML: CLOB mapping NO
+X120 XML parameters in SQL routines YES
+X121 XML parameters in external routines YES
+X131 Query-level XMLBINARY clause NO
+X132 XMLBINARY clause in DML NO
+X133 XMLBINARY clause in DDL NO
+X134 XMLBINARY clause in compound statements NO
+X135 XMLBINARY clause in subqueries NO