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

Commit4c488e8

Browse files
committed
Update SQL conformance information about XML features.
1 parentec020e1 commit4c488e8

File tree

3 files changed

+83
-26
lines changed

3 files changed

+83
-26
lines changed

‎doc/src/sgml/features.sgml

Lines changed: 21 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/features.sgml,v 2.26 2007/01/31 20:56:17 momjian Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/features.sgml,v 2.27 2007/02/03 17:59:35 petere Exp $ -->
22

33
<appendix id="features">
44
<title>SQL Conformance</title>
@@ -14,19 +14,21 @@
1414
<para>
1515
The formal name of the SQL standard is ISO/IEC 9075 <quote>Database
1616
Language SQL</quote>. A revised version of the standard is released
17-
from time to time; the most recent one appearing in late 2003. That
18-
version is referred to as ISO/IEC 9075:2003, or simply as SQL:2003.
19-
The versions prior to that were SQL:1999 and SQL-92. Each version
17+
from time to time; the most recent full update appearing in 2003,
18+
with a partial update appearing in 2006. The 2003 version is
19+
referred to as ISO/IEC 9075:2003, or simply as SQL:2003. The
20+
versions prior to that were SQL:1999 and SQL-92. Each version
2021
replaces the previous one, so claims of conformance to earlier
2122
versions have no official merit.
2223
<productname>PostgreSQL</productname> development aims for
2324
conformance with the latest official version of the standard where
2425
such conformance does not contradict traditional features or common
25-
sense. The PostgreSQL project was not represented in the ISO/IEC
26-
9075 Working Group during the preparation of SQL:2003. Even so,
27-
many of the features required by SQL:2003 are already supported,
28-
though sometimes with slightly differing syntax or function.
29-
Further moves towards conformance should be expected in later releases.
26+
sense. The PostgreSQL project is not represented in the ISO/IEC
27+
9075 Working Group during the preparation of the SQL standard
28+
releases, but even so, many of the features required by the SQL
29+
standard are supported, though sometimes with slightly differing
30+
syntax or function. Further moves towards conformance can be
31+
expected over time.
3032
</para>
3133

3234
<para>
@@ -56,20 +58,20 @@
5658
are not consecutively numbered.
5759

5860
<itemizedlist>
59-
<listitem><para>ISO/IEC 9075-1 Framework (<acronym>SQL/Framework</acronym>)</para></listitem>
60-
<listitem><para>ISO/IEC 9075-2 Foundation (<acronym>SQL/Foundation</acronym>)</para></listitem>
61-
<listitem><para>ISO/IEC 9075-3 Call Level Interface (<acronym>SQL/CLI</acronym>)</para></listitem>
62-
<listitem><para>ISO/IEC 9075-4 Persistent Stored Modules (<acronym>SQL/PSM</acronym>)</para></listitem>
63-
<listitem><para>ISO/IEC 9075-9 Management of External Data (<acronym>SQL/MED</acronym>)</para></listitem>
64-
<listitem><para>ISO/IEC 9075-10 Object Language Bindings (<acronym>SQL/OLB</acronym>)</para></listitem>
65-
<listitem><para>ISO/IEC 9075-11 Information and Definition Schemas (<acronym>SQL/Schemata</acronym>)</para></listitem>
66-
<listitem><para>ISO/IEC 9075-13 Routines and Types using the Java Language (<acronym>SQL/JRT</acronym>)</para></listitem>
67-
<listitem><para>ISO/IEC 9075-14 XML-related specifications (<acronym>SQL/XML</acronym>)</para></listitem>
61+
<listitem><para>ISO/IEC 9075-1 Framework (SQL/Framework)</para></listitem>
62+
<listitem><para>ISO/IEC 9075-2 Foundation (SQL/Foundation)</para></listitem>
63+
<listitem><para>ISO/IEC 9075-3 Call Level Interface (SQL/CLI)</para></listitem>
64+
<listitem><para>ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM)</para></listitem>
65+
<listitem><para>ISO/IEC 9075-9 Management of External Data (SQL/MED)</para></listitem>
66+
<listitem><para>ISO/IEC 9075-10 Object Language Bindings (SQL/OLB)</para></listitem>
67+
<listitem><para>ISO/IEC 9075-11 Information and Definition Schemas (SQL/Schemata)</para></listitem>
68+
<listitem><para>ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT)</para></listitem>
69+
<listitem><para>ISO/IEC 9075-14 XML-related specifications (SQL/XML)</para></listitem>
6870
</itemizedlist>
6971
</para>
7072

7173
<para>
72-
<productname>PostgreSQL</productname> covers parts 1, 2, and11.
74+
<productname>PostgreSQL</productname> covers parts 1, 2,11,and14.
7375
Part 3 is similar to the ODBC interface, and part 4 is similar to
7476
the <application>PL/pgSQL</application> programming language, but
7577
exact conformance is not specifically intended or verified in either

‎src/backend/catalog/information_schema.sql

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
*
55
* Copyright (c) 2003-2007, PostgreSQL Global Development Group
66
*
7-
* $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.40 2007/01/16 18:32:26 tgl Exp $
7+
* $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.41 2007/02/03 17:59:35 petere Exp $
88
*/
99

1010
/*
@@ -1615,12 +1615,12 @@ CREATE TABLE sql_parts (
16151615
INSERT INTO sql_partsVALUES ('1','Framework (SQL/Framework)','NO',NULL,'');
16161616
INSERT INTO sql_partsVALUES ('2','Foundation (SQL/Foundation)','NO',NULL,'');
16171617
INSERT INTO sql_partsVALUES ('3','Call-Level Interface (SQL/CLI)','NO',NULL,'');
1618-
INSERT INTO sql_partsVALUES ('4','Persistent Stored Modules (SQL/PSM)',NULL,'');
1619-
INSERT INTO sql_partsVALUES ('9','Management of External Data (SQL/MED)',NULL,'');
1620-
INSERT INTO sql_partsVALUES ('10','Object Language Bindings (SQL/OLB)',NULL,'');
1621-
INSERT INTO sql_partsVALUES ('11','Information and Definition Schema (SQL/Schemata)',NULL,'');
1622-
INSERT INTO sql_partsVALUES ('13','Routines and Types Using the Java Programming Language (SQL/JRT)',NULL,'');
1623-
INSERT INTO sql_partsVALUES ('14','XML-Related Specifications (SQL/XML)',NULL,'');
1618+
INSERT INTO sql_partsVALUES ('4','Persistent Stored Modules (SQL/PSM)','NO',NULL,'');
1619+
INSERT INTO sql_partsVALUES ('9','Management of External Data (SQL/MED)','NO',NULL,'');
1620+
INSERT INTO sql_partsVALUES ('10','Object Language Bindings (SQL/OLB)','NO',NULL,'');
1621+
INSERT INTO sql_partsVALUES ('11','Information and Definition Schema (SQL/Schemata)','NO',NULL,'');
1622+
INSERT INTO sql_partsVALUES ('13','Routines and Types Using the Java Programming Language (SQL/JRT)','NO',NULL,'');
1623+
INSERT INTO sql_partsVALUES ('14','XML-Related Specifications (SQL/XML)','YES',NULL,'');
16241624

16251625

16261626
/*

‎src/backend/catalog/sql_features.txt

Lines changed: 55 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -437,3 +437,58 @@ T652SQL-dynamic statements in SQL routinesNO
437437
T653SQL-schema statements in external routinesNO
438438
T654SQL-dynamic statements in external routinesNO
439439
T655Cyclically dependent routinesNO
440+
X010XML typeYES
441+
X011Arrays of XML typeYES
442+
X012Multisets of XML typeNO
443+
X013Distinct types of XML typeNO
444+
X014Attributes of XML typeNO
445+
X015Fields of XML typeNO
446+
X016Persistent XML valuesYES
447+
X020XML concatenationYES
448+
X031XMLElementYES
449+
X032XMLForestYES
450+
X033XMLRootYES
451+
X034XMLAggYES
452+
X035XMLAgg: ORDER BY optionNO
453+
X036XMLCommentYES
454+
X037XMLPIYES
455+
X041Basic table mapping: nulls absentNO
456+
X042Basic table mapping: null as nilNO
457+
X043Basic table mapping: table as forestNO
458+
X044Basic table mapping: table as elementNO
459+
X045Basic table mapping: with target namespaceNO
460+
X046Basic table mapping: data mappingNO
461+
X047Basic table mapping: metadata mappingNO
462+
X048Basic table mapping: base64 encoding of binary stringsNO
463+
X049Basic table mapping: hex encoding of binary stringsNO
464+
X051Advanced table mapping: nulls absentNO
465+
X052Advanced table mapping: null as nilNO
466+
X053Advanced table mapping: table as forestNO
467+
X054Advanced table mapping: table as elementNO
468+
X055Advanced table mapping: target namespaceNO
469+
X056Advanced table mapping: data mappingNO
470+
X057Advanced table mapping: metadata mappingNO
471+
X058Advanced table mapping: base64 encoding of binary stringsNO
472+
X059Advanced table mapping: hex encoding of binary stringsNO
473+
X060XMLParse: CONTENT optionYES
474+
X061XMLParse: DOCUMENT optionYES
475+
X062XMLParse: explicit WHITESPACE optionYES
476+
X070XMLSerialize: CONTENT optionYES
477+
X071XMLSerialize: DOCUMENT optionYES
478+
X080Namespaces in XML publishingNO
479+
X081Query-level XML namespace declarationsNO
480+
X082XML namespace declarations in DMLNO
481+
X083XML namespace declarations in DDLNO
482+
X084XML namespace declarations in compound statementsNO
483+
X090XML document predicateYES
484+
X100Host language support for XML: CONTENT optionNO
485+
X101Host language support for XML: DOCUMENT optionNO
486+
X110Host language support for XML: VARCHAR mappingNO
487+
X111Host language support for XML: CLOB mappingNO
488+
X120XML parameters in SQL routinesYES
489+
X121XML parameters in external routinesYES
490+
X131Query-level XMLBINARY clauseNO
491+
X132XMLBINARY clause in DMLNO
492+
X133XMLBINARY clause in DDLNO
493+
X134XMLBINARY clause in compound statementsNO
494+
X135XMLBINARY clause in subqueriesNO

0 commit comments

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