文件操作 - unsupported-features-sql-standard.html
返回文件管理
返回主菜单
删除本文件
文件: /usr/share/doc/postgresql-9.2.24/html/unsupported-features-sql-standard.html
编辑文件内容
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Unsupported Features</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.2.24 Documentation" HREF="index.html"><LINK REL="UP" TITLE="SQL Conformance" HREF="features.html"><LINK REL="PREVIOUS" TITLE="Supported Features" HREF="features-sql-standard.html"><LINK REL="NEXT" TITLE="Release Notes" HREF="release.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2017-11-06T22:43:11"></HEAD ><BODY CLASS="SECT1" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.2.24 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Supported Features" HREF="features-sql-standard.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="features.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" >Appendix D. SQL Conformance</TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Release Notes" HREF="release.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="UNSUPPORTED-FEATURES-SQL-STANDARD" >D.2. Unsupported Features</A ></H1 ><P > The following features defined in <ACRONYM CLASS="ACRONYM" >SQL:2011</ACRONYM > are not implemented in this release of <SPAN CLASS="PRODUCTNAME" >PostgreSQL</SPAN >. In a few cases, equivalent functionality is available. <DIV CLASS="INFORMALTABLE" ><P ></P ><A NAME="AEN109215" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><COL><COL><THEAD ><TR ><TH >Identifier</TH ><TH >Package</TH ><TH >Description</TH ><TH >Comment</TH ></TR ></THEAD ><TBODY ><TR ><TD >B011</TD ><TD > </TD ><TD >Embedded Ada</TD ><TD > </TD ></TR ><TR ><TD >B013</TD ><TD > </TD ><TD >Embedded COBOL</TD ><TD > </TD ></TR ><TR ><TD >B014</TD ><TD > </TD ><TD >Embedded Fortran</TD ><TD > </TD ></TR ><TR ><TD >B015</TD ><TD > </TD ><TD >Embedded MUMPS</TD ><TD > </TD ></TR ><TR ><TD >B016</TD ><TD > </TD ><TD >Embedded Pascal</TD ><TD > </TD ></TR ><TR ><TD >B017</TD ><TD > </TD ><TD >Embedded PL/I</TD ><TD > </TD ></TR ><TR ><TD >B031</TD ><TD > </TD ><TD >Basic dynamic SQL</TD ><TD > </TD ></TR ><TR ><TD >B032</TD ><TD > </TD ><TD >Extended dynamic SQL</TD ><TD > </TD ></TR ><TR ><TD >B032-01</TD ><TD > </TD ><TD ><describe input statement></TD ><TD > </TD ></TR ><TR ><TD >B033</TD ><TD > </TD ><TD >Untyped SQL-invoked function arguments</TD ><TD > </TD ></TR ><TR ><TD >B034</TD ><TD > </TD ><TD >Dynamic specification of cursor attributes</TD ><TD > </TD ></TR ><TR ><TD >B035</TD ><TD > </TD ><TD >Non-extended descriptor names</TD ><TD > </TD ></TR ><TR ><TD >B041</TD ><TD > </TD ><TD >Extensions to embedded SQL exception declarations</TD ><TD > </TD ></TR ><TR ><TD >B051</TD ><TD > </TD ><TD >Enhanced execution rights</TD ><TD > </TD ></TR ><TR ><TD >B111</TD ><TD > </TD ><TD >Module language Ada</TD ><TD > </TD ></TR ><TR ><TD >B112</TD ><TD > </TD ><TD >Module language C</TD ><TD > </TD ></TR ><TR ><TD >B113</TD ><TD > </TD ><TD >Module language COBOL</TD ><TD > </TD ></TR ><TR ><TD >B114</TD ><TD > </TD ><TD >Module language Fortran</TD ><TD > </TD ></TR ><TR ><TD >B115</TD ><TD > </TD ><TD >Module language MUMPS</TD ><TD > </TD ></TR ><TR ><TD >B116</TD ><TD > </TD ><TD >Module language Pascal</TD ><TD > </TD ></TR ><TR ><TD >B117</TD ><TD > </TD ><TD >Module language PL/I</TD ><TD > </TD ></TR ><TR ><TD >B121</TD ><TD > </TD ><TD >Routine language Ada</TD ><TD > </TD ></TR ><TR ><TD >B122</TD ><TD > </TD ><TD >Routine language C</TD ><TD > </TD ></TR ><TR ><TD >B123</TD ><TD > </TD ><TD >Routine language COBOL</TD ><TD > </TD ></TR ><TR ><TD >B124</TD ><TD > </TD ><TD >Routine language Fortran</TD ><TD > </TD ></TR ><TR ><TD >B125</TD ><TD > </TD ><TD >Routine language MUMPS</TD ><TD > </TD ></TR ><TR ><TD >B126</TD ><TD > </TD ><TD >Routine language Pascal</TD ><TD > </TD ></TR ><TR ><TD >B127</TD ><TD > </TD ><TD >Routine language PL/I</TD ><TD > </TD ></TR ><TR ><TD >B128</TD ><TD > </TD ><TD >Routine language SQL</TD ><TD > </TD ></TR ><TR ><TD >B211</TD ><TD > </TD ><TD >Module language Ada: VARCHAR and NUMERIC support</TD ><TD > </TD ></TR ><TR ><TD >B221</TD ><TD > </TD ><TD >Routine language Ada: VARCHAR and NUMERIC support</TD ><TD > </TD ></TR ><TR ><TD >E153</TD ><TD >Core</TD ><TD >Updatable queries with subqueries</TD ><TD > </TD ></TR ><TR ><TD >E182</TD ><TD >Core</TD ><TD >Module language</TD ><TD > </TD ></TR ><TR ><TD >F054</TD ><TD > </TD ><TD >TIMESTAMP in DATE type precedence list</TD ><TD > </TD ></TR ><TR ><TD >F121</TD ><TD > </TD ><TD >Basic diagnostics management</TD ><TD > </TD ></TR ><TR ><TD >F121-01</TD ><TD > </TD ><TD >GET DIAGNOSTICS statement</TD ><TD > </TD ></TR ><TR ><TD >F121-02</TD ><TD > </TD ><TD >SET TRANSACTION statement: DIAGNOSTICS SIZE clause</TD ><TD > </TD ></TR ><TR ><TD >F122</TD ><TD > </TD ><TD >Enhanced diagnostics management</TD ><TD > </TD ></TR ><TR ><TD >F123</TD ><TD > </TD ><TD >All diagnostics</TD ><TD > </TD ></TR ><TR ><TD >F181</TD ><TD >Core</TD ><TD >Multiple module support</TD ><TD > </TD ></TR ><TR ><TD >F202</TD ><TD > </TD ><TD >TRUNCATE TABLE: identity column restart option</TD ><TD > </TD ></TR ><TR ><TD >F263</TD ><TD > </TD ><TD >Comma-separated predicates in simple CASE expression</TD ><TD > </TD ></TR ><TR ><TD >F291</TD ><TD > </TD ><TD >UNIQUE predicate</TD ><TD > </TD ></TR ><TR ><TD >F301</TD ><TD > </TD ><TD >CORRESPONDING in query expressions</TD ><TD > </TD ></TR ><TR ><TD >F311</TD ><TD >Core</TD ><TD >Schema definition statement</TD ><TD > </TD ></TR ><TR ><TD >F311-04</TD ><TD >Core</TD ><TD >CREATE VIEW: WITH CHECK OPTION</TD ><TD > </TD ></TR ><TR ><TD >F312</TD ><TD > </TD ><TD >MERGE statement</TD ><TD > </TD ></TR ><TR ><TD >F313</TD ><TD > </TD ><TD >Enhanced MERGE statement</TD ><TD > </TD ></TR ><TR ><TD >F314</TD ><TD > </TD ><TD >MERGE statement with DELETE branch</TD ><TD > </TD ></TR ><TR ><TD >F341</TD ><TD > </TD ><TD >Usage tables</TD ><TD >no ROUTINE_*_USAGE tables</TD ></TR ><TR ><TD >F384</TD ><TD > </TD ><TD >Drop identity property clause</TD ><TD > </TD ></TR ><TR ><TD >F385</TD ><TD > </TD ><TD >Drop column generation expression clause</TD ><TD > </TD ></TR ><TR ><TD >F386</TD ><TD > </TD ><TD >Set identity column generation clause</TD ><TD > </TD ></TR ><TR ><TD >F394</TD ><TD > </TD ><TD >Optional normal form specification</TD ><TD > </TD ></TR ><TR ><TD >F403</TD ><TD > </TD ><TD >Partitioned joined tables</TD ><TD > </TD ></TR ><TR ><TD >F451</TD ><TD > </TD ><TD >Character set definition</TD ><TD > </TD ></TR ><TR ><TD >F461</TD ><TD > </TD ><TD >Named character sets</TD ><TD > </TD ></TR ><TR ><TD >F492</TD ><TD > </TD ><TD >Optional table constraint enforcement</TD ><TD > </TD ></TR ><TR ><TD >F521</TD ><TD >Enhanced integrity management</TD ><TD >Assertions</TD ><TD > </TD ></TR ><TR ><TD >F671</TD ><TD >Enhanced integrity management</TD ><TD >Subqueries in CHECK</TD ><TD >intentionally omitted</TD ></TR ><TR ><TD >F693</TD ><TD > </TD ><TD >SQL-session and client module collations</TD ><TD > </TD ></TR ><TR ><TD >F695</TD ><TD > </TD ><TD >Translation support</TD ><TD > </TD ></TR ><TR ><TD >F696</TD ><TD > </TD ><TD >Additional translation documentation</TD ><TD > </TD ></TR ><TR ><TD >F721</TD ><TD > </TD ><TD >Deferrable constraints</TD ><TD >foreign and unique keys only</TD ></TR ><TR ><TD >F741</TD ><TD > </TD ><TD >Referential MATCH types</TD ><TD >no partial match yet</TD ></TR ><TR ><TD >F751</TD ><TD > </TD ><TD >View CHECK enhancements</TD ><TD > </TD ></TR ><TR ><TD >F812</TD ><TD >Core</TD ><TD >Basic flagging</TD ><TD > </TD ></TR ><TR ><TD >F813</TD ><TD > </TD ><TD >Extended flagging</TD ><TD > </TD ></TR ><TR ><TD >F821</TD ><TD > </TD ><TD >Local table references</TD ><TD > </TD ></TR ><TR ><TD >F831</TD ><TD > </TD ><TD >Full cursor update</TD ><TD > </TD ></TR ><TR ><TD >F831-01</TD ><TD > </TD ><TD >Updatable scrollable cursors</TD ><TD > </TD ></TR ><TR ><TD >F831-02</TD ><TD > </TD ><TD >Updatable ordered cursors</TD ><TD > </TD ></TR ><TR ><TD >F841</TD ><TD > </TD ><TD >LIKE_REGEX predicate</TD ><TD > </TD ></TR ><TR ><TD >F842</TD ><TD > </TD ><TD >OCCURENCES_REGEX function</TD ><TD > </TD ></TR ><TR ><TD >F843</TD ><TD > </TD ><TD >POSITION_REGEX function</TD ><TD > </TD ></TR ><TR ><TD >F844</TD ><TD > </TD ><TD >SUBSTRING_REGEX function</TD ><TD > </TD ></TR ><TR ><TD >F845</TD ><TD > </TD ><TD >TRANSLATE_REGEX function</TD ><TD > </TD ></TR ><TR ><TD >F846</TD ><TD > </TD ><TD >Octet support in regular expression operators</TD ><TD > </TD ></TR ><TR ><TD >F847</TD ><TD > </TD ><TD >Nonconstant regular expressions</TD ><TD > </TD ></TR ><TR ><TD >F866</TD ><TD > </TD ><TD >FETCH FIRST clause: PERCENT option</TD ><TD > </TD ></TR ><TR ><TD >F867</TD ><TD > </TD ><TD >FETCH FIRST clause: WITH TIES option</TD ><TD > </TD ></TR ><TR ><TD >S011</TD ><TD >Core</TD ><TD >Distinct data types</TD ><TD > </TD ></TR ><TR ><TD >S011-01</TD ><TD >Core</TD ><TD >USER_DEFINED_TYPES view</TD ><TD > </TD ></TR ><TR ><TD >S023</TD ><TD >Basic object support</TD ><TD >Basic structured types</TD ><TD > </TD ></TR ><TR ><TD >S024</TD ><TD >Enhanced object support</TD ><TD >Enhanced structured types</TD ><TD > </TD ></TR ><TR ><TD >S025</TD ><TD > </TD ><TD >Final structured types</TD ><TD > </TD ></TR ><TR ><TD >S026</TD ><TD > </TD ><TD >Self-referencing structured types</TD ><TD > </TD ></TR ><TR ><TD >S027</TD ><TD > </TD ><TD >Create method by specific method name</TD ><TD > </TD ></TR ><TR ><TD >S028</TD ><TD > </TD ><TD >Permutable UDT options list</TD ><TD > </TD ></TR ><TR ><TD >S041</TD ><TD >Basic object support</TD ><TD >Basic reference types</TD ><TD > </TD ></TR ><TR ><TD >S043</TD ><TD >Enhanced object support</TD ><TD >Enhanced reference types</TD ><TD > </TD ></TR ><TR ><TD >S051</TD ><TD >Basic object support</TD ><TD >Create table of type</TD ><TD >partially supported</TD ></TR ><TR ><TD >S081</TD ><TD >Enhanced object support</TD ><TD >Subtables</TD ><TD > </TD ></TR ><TR ><TD >S091</TD ><TD > </TD ><TD >Basic array support</TD ><TD >partially supported</TD ></TR ><TR ><TD >S091-01</TD ><TD > </TD ><TD >Arrays of built-in data types</TD ><TD > </TD ></TR ><TR ><TD >S091-02</TD ><TD > </TD ><TD >Arrays of distinct types</TD ><TD > </TD ></TR ><TR ><TD >S091-03</TD ><TD > </TD ><TD >Array expressions</TD ><TD > </TD ></TR ><TR ><TD >S094</TD ><TD > </TD ><TD >Arrays of reference types</TD ><TD > </TD ></TR ><TR ><TD >S097</TD ><TD > </TD ><TD >Array element assignment</TD ><TD > </TD ></TR ><TR ><TD >S151</TD ><TD >Basic object support</TD ><TD >Type predicate</TD ><TD > </TD ></TR ><TR ><TD >S161</TD ><TD >Enhanced object support</TD ><TD >Subtype treatment</TD ><TD > </TD ></TR ><TR ><TD >S162</TD ><TD > </TD ><TD >Subtype treatment for references</TD ><TD > </TD ></TR ><TR ><TD >S202</TD ><TD > </TD ><TD >SQL-invoked routines on multisets</TD ><TD > </TD ></TR ><TR ><TD >S231</TD ><TD >Enhanced object support</TD ><TD >Structured type locators</TD ><TD > </TD ></TR ><TR ><TD >S232</TD ><TD > </TD ><TD >Array locators</TD ><TD > </TD ></TR ><TR ><TD >S233</TD ><TD > </TD ><TD >Multiset locators</TD ><TD > </TD ></TR ><TR ><TD >S241</TD ><TD > </TD ><TD >Transform functions</TD ><TD > </TD ></TR ><TR ><TD >S242</TD ><TD > </TD ><TD >Alter transform statement</TD ><TD > </TD ></TR ><TR ><TD >S251</TD ><TD > </TD ><TD >User-defined orderings</TD ><TD > </TD ></TR ><TR ><TD >S261</TD ><TD > </TD ><TD >Specific type method</TD ><TD > </TD ></TR ><TR ><TD >S271</TD ><TD > </TD ><TD >Basic multiset support</TD ><TD > </TD ></TR ><TR ><TD >S272</TD ><TD > </TD ><TD >Multisets of user-defined types</TD ><TD > </TD ></TR ><TR ><TD >S274</TD ><TD > </TD ><TD >Multisets of reference types</TD ><TD > </TD ></TR ><TR ><TD >S275</TD ><TD > </TD ><TD >Advanced multiset support</TD ><TD > </TD ></TR ><TR ><TD >S281</TD ><TD > </TD ><TD >Nested collection types</TD ><TD > </TD ></TR ><TR ><TD >S291</TD ><TD > </TD ><TD >Unique constraint on entire row</TD ><TD > </TD ></TR ><TR ><TD >S301</TD ><TD > </TD ><TD >Enhanced UNNEST</TD ><TD > </TD ></TR ><TR ><TD >S401</TD ><TD > </TD ><TD >Distinct types based on array types</TD ><TD > </TD ></TR ><TR ><TD >S402</TD ><TD > </TD ><TD >Distinct types based on distinct types</TD ><TD > </TD ></TR ><TR ><TD >S403</TD ><TD > </TD ><TD >MAX_CARDINALITY</TD ><TD > </TD ></TR ><TR ><TD >S404</TD ><TD > </TD ><TD >TRIM_ARRAY</TD ><TD > </TD ></TR ><TR ><TD >T011</TD ><TD > </TD ><TD >Timestamp in Information Schema</TD ><TD > </TD ></TR ><TR ><TD >T021</TD ><TD > </TD ><TD >BINARY and VARBINARY data types</TD ><TD > </TD ></TR ><TR ><TD >T022</TD ><TD > </TD ><TD >Advanced support for BINARY and VARBINARY data types</TD ><TD > </TD ></TR ><TR ><TD >T023</TD ><TD > </TD ><TD >Compound binary literal</TD ><TD > </TD ></TR ><TR ><TD >T024</TD ><TD > </TD ><TD >Spaces in binary literals</TD ><TD > </TD ></TR ><TR ><TD >T041</TD ><TD >Basic object support</TD ><TD >Basic LOB data type support</TD ><TD > </TD ></TR ><TR ><TD >T041-01</TD ><TD >Basic object support</TD ><TD >BLOB data type</TD ><TD > </TD ></TR ><TR ><TD >T041-02</TD ><TD >Basic object support</TD ><TD >CLOB data type</TD ><TD > </TD ></TR ><TR ><TD >T041-03</TD ><TD >Basic object support</TD ><TD >POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types</TD ><TD > </TD ></TR ><TR ><TD >T041-04</TD ><TD >Basic object support</TD ><TD >Concatenation of LOB data types</TD ><TD > </TD ></TR ><TR ><TD >T041-05</TD ><TD >Basic object support</TD ><TD >LOB locator: non-holdable</TD ><TD > </TD ></TR ><TR ><TD >T042</TD ><TD > </TD ><TD >Extended LOB data type support</TD ><TD > </TD ></TR ><TR ><TD >T043</TD ><TD > </TD ><TD >Multiplier T</TD ><TD > </TD ></TR ><TR ><TD >T044</TD ><TD > </TD ><TD >Multiplier P</TD ><TD > </TD ></TR ><TR ><TD >T051</TD ><TD > </TD ><TD >Row types</TD ><TD > </TD ></TR ><TR ><TD >T052</TD ><TD > </TD ><TD >MAX and MIN for row types</TD ><TD > </TD ></TR ><TR ><TD >T053</TD ><TD > </TD ><TD >Explicit aliases for all-fields reference</TD ><TD > </TD ></TR ><TR ><TD >T061</TD ><TD > </TD ><TD >UCS support</TD ><TD > </TD ></TR ><TR ><TD >T101</TD ><TD > </TD ><TD >Enhanced nullability determination</TD ><TD > </TD ></TR ><TR ><TD >T111</TD ><TD > </TD ><TD >Updatable joins, unions, and columns</TD ><TD > </TD ></TR ><TR ><TD >T174</TD ><TD > </TD ><TD >Identity columns</TD ><TD > </TD ></TR ><TR ><TD >T175</TD ><TD > </TD ><TD >Generated columns</TD ><TD > </TD ></TR ><TR ><TD >T176</TD ><TD > </TD ><TD >Sequence generator support</TD ><TD > </TD ></TR ><TR ><TD >T177</TD ><TD > </TD ><TD >Sequence generator support: simple restart option</TD ><TD > </TD ></TR ><TR ><TD >T178</TD ><TD > </TD ><TD >Identity columns: simple restart option</TD ><TD > </TD ></TR ><TR ><TD >T180</TD ><TD > </TD ><TD >System-versioned tables</TD ><TD > </TD ></TR ><TR ><TD >T181</TD ><TD > </TD ><TD >Application-time period tables</TD ><TD > </TD ></TR ><TR ><TD >T211</TD ><TD >Active database, Enhanced integrity management</TD ><TD >Basic trigger capability</TD ><TD > </TD ></TR ><TR ><TD >T211-06</TD ><TD >Active database, Enhanced integrity management</TD ><TD >Support for run-time rules for the interaction of triggers and constraints</TD ><TD > </TD ></TR ><TR ><TD >T211-08</TD ><TD >Active database, Enhanced integrity management</TD ><TD >Multiple triggers for the same event are executed in the order in which they were created in the catalog</TD ><TD >intentionally omitted</TD ></TR ><TR ><TD >T251</TD ><TD > </TD ><TD >SET TRANSACTION statement: LOCAL option</TD ><TD > </TD ></TR ><TR ><TD >T261</TD ><TD > </TD ><TD >Chained transactions</TD ><TD > </TD ></TR ><TR ><TD >T272</TD ><TD > </TD ><TD >Enhanced savepoint management</TD ><TD > </TD ></TR ><TR ><TD >T285</TD ><TD > </TD ><TD >Enhanced derived column names</TD ><TD > </TD ></TR ><TR ><TD >T301</TD ><TD > </TD ><TD >Functional dependencies</TD ><TD >partially supported</TD ></TR ><TR ><TD >T321</TD ><TD >Core</TD ><TD >Basic SQL-invoked routines</TD ><TD > </TD ></TR ><TR ><TD >T321-02</TD ><TD >Core</TD ><TD >User-defined stored procedures with no overloading</TD ><TD > </TD ></TR ><TR ><TD >T321-04</TD ><TD >Core</TD ><TD >CALL statement</TD ><TD > </TD ></TR ><TR ><TD >T321-05</TD ><TD >Core</TD ><TD >RETURN statement</TD ><TD > </TD ></TR ><TR ><TD >T322</TD ><TD >PSM</TD ><TD >Declared data type attributes</TD ><TD > </TD ></TR ><TR ><TD >T324</TD ><TD > </TD ><TD >Explicit security for SQL routines</TD ><TD > </TD ></TR ><TR ><TD >T325</TD ><TD > </TD ><TD >Qualified SQL parameter references</TD ><TD > </TD ></TR ><TR ><TD >T326</TD ><TD > </TD ><TD >Table functions</TD ><TD > </TD ></TR ><TR ><TD >T332</TD ><TD > </TD ><TD >Extended roles</TD ><TD >mostly supported</TD ></TR ><TR ><TD >T431</TD ><TD >OLAP</TD ><TD >Extended grouping capabilities</TD ><TD > </TD ></TR ><TR ><TD >T432</TD ><TD > </TD ><TD >Nested and concatenated GROUPING SETS</TD ><TD > </TD ></TR ><TR ><TD >T433</TD ><TD > </TD ><TD >Multiargument GROUPING function</TD ><TD > </TD ></TR ><TR ><TD >T434</TD ><TD > </TD ><TD >GROUP BY DISTINCT</TD ><TD > </TD ></TR ><TR ><TD >T471</TD ><TD > </TD ><TD >Result sets return value</TD ><TD > </TD ></TR ><TR ><TD >T472</TD ><TD > </TD ><TD >DESCRIBE CURSOR</TD ><TD > </TD ></TR ><TR ><TD >T491</TD ><TD > </TD ><TD >LATERAL derived table</TD ><TD > </TD ></TR ><TR ><TD >T495</TD ><TD > </TD ><TD >Combined data change and retrieval</TD ><TD >different syntax</TD ></TR ><TR ><TD >T502</TD ><TD > </TD ><TD >Period predicates</TD ><TD > </TD ></TR ><TR ><TD >T511</TD ><TD > </TD ><TD >Transaction counts</TD ><TD > </TD ></TR ><TR ><TD >T521</TD ><TD > </TD ><TD >Named arguments in CALL statement</TD ><TD > </TD ></TR ><TR ><TD >T522</TD ><TD > </TD ><TD >Default values for IN parameters of SQL-invoked procedures</TD ><TD > </TD ></TR ><TR ><TD >T541</TD ><TD > </TD ><TD >Updatable table references</TD ><TD > </TD ></TR ><TR ><TD >T561</TD ><TD > </TD ><TD >Holdable locators</TD ><TD > </TD ></TR ><TR ><TD >T571</TD ><TD > </TD ><TD >Array-returning external SQL-invoked functions</TD ><TD > </TD ></TR ><TR ><TD >T572</TD ><TD > </TD ><TD >Multiset-returning external SQL-invoked functions</TD ><TD > </TD ></TR ><TR ><TD >T601</TD ><TD > </TD ><TD >Local cursor references</TD ><TD > </TD ></TR ><TR ><TD >T611</TD ><TD >OLAP</TD ><TD >Elementary OLAP operations</TD ><TD >most forms supported</TD ></TR ><TR ><TD >T612</TD ><TD > </TD ><TD >Advanced OLAP operations</TD ><TD >some forms supported</TD ></TR ><TR ><TD >T613</TD ><TD > </TD ><TD >Sampling</TD ><TD > </TD ></TR ><TR ><TD >T616</TD ><TD > </TD ><TD >Null treatment option for LEAD and LAG functions</TD ><TD > </TD ></TR ><TR ><TD >T618</TD ><TD > </TD ><TD >NTH_VALUE function</TD ><TD >function exists, but some options missing</TD ></TR ><TR ><TD >T619</TD ><TD > </TD ><TD >Nested window functions</TD ><TD > </TD ></TR ><TR ><TD >T620</TD ><TD > </TD ><TD >WINDOW clause: GROUPS option</TD ><TD > </TD ></TR ><TR ><TD >T641</TD ><TD > </TD ><TD >Multiple column assignment</TD ><TD >only some syntax variants supported</TD ></TR ><TR ><TD >T652</TD ><TD > </TD ><TD >SQL-dynamic statements in SQL routines</TD ><TD > </TD ></TR ><TR ><TD >T653</TD ><TD > </TD ><TD >SQL-schema statements in external routines</TD ><TD > </TD ></TR ><TR ><TD >T654</TD ><TD > </TD ><TD >SQL-dynamic statements in external routines</TD ><TD > </TD ></TR ><TR ><TD >M001</TD ><TD > </TD ><TD >Datalinks</TD ><TD > </TD ></TR ><TR ><TD >M002</TD ><TD > </TD ><TD >Datalinks via SQL/CLI</TD ><TD > </TD ></TR ><TR ><TD >M003</TD ><TD > </TD ><TD >Datalinks via Embedded SQL</TD ><TD > </TD ></TR ><TR ><TD >M004</TD ><TD > </TD ><TD >Foreign data support</TD ><TD >partially supported</TD ></TR ><TR ><TD >M005</TD ><TD > </TD ><TD >Foreign schema support</TD ><TD > </TD ></TR ><TR ><TD >M006</TD ><TD > </TD ><TD >GetSQLString routine</TD ><TD > </TD ></TR ><TR ><TD >M007</TD ><TD > </TD ><TD >TransmitRequest</TD ><TD > </TD ></TR ><TR ><TD >M009</TD ><TD > </TD ><TD >GetOpts and GetStatistics routines</TD ><TD > </TD ></TR ><TR ><TD >M010</TD ><TD > </TD ><TD >Foreign data wrapper support</TD ><TD > </TD ></TR ><TR ><TD >M011</TD ><TD > </TD ><TD >Datalinks via Ada</TD ><TD > </TD ></TR ><TR ><TD >M012</TD ><TD > </TD ><TD >Datalinks via C</TD ><TD > </TD ></TR ><TR ><TD >M013</TD ><TD > </TD ><TD >Datalinks via COBOL</TD ><TD > </TD ></TR ><TR ><TD >M014</TD ><TD > </TD ><TD >Datalinks via Fortran</TD ><TD > </TD ></TR ><TR ><TD >M015</TD ><TD > </TD ><TD >Datalinks via M</TD ><TD > </TD ></TR ><TR ><TD >M016</TD ><TD > </TD ><TD >Datalinks via Pascal</TD ><TD > </TD ></TR ><TR ><TD >M017</TD ><TD > </TD ><TD >Datalinks via PL/I</TD ><TD > </TD ></TR ><TR ><TD >M018</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in Ada</TD ><TD > </TD ></TR ><TR ><TD >M019</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in C</TD ><TD > </TD ></TR ><TR ><TD >M020</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in COBOL</TD ><TD > </TD ></TR ><TR ><TD >M021</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in Fortran</TD ><TD > </TD ></TR ><TR ><TD >M022</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in MUMPS</TD ><TD > </TD ></TR ><TR ><TD >M023</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in Pascal</TD ><TD > </TD ></TR ><TR ><TD >M024</TD ><TD > </TD ><TD >Foreign data wrapper interface routines in PL/I</TD ><TD > </TD ></TR ><TR ><TD >M030</TD ><TD > </TD ><TD >SQL-server foreign data support</TD ><TD > </TD ></TR ><TR ><TD >M031</TD ><TD > </TD ><TD >Foreign data wrapper general routines</TD ><TD > </TD ></TR ><TR ><TD >X012</TD ><TD > </TD ><TD >Multisets of XML type</TD ><TD > </TD ></TR ><TR ><TD >X013</TD ><TD > </TD ><TD >Distinct types of XML type</TD ><TD > </TD ></TR ><TR ><TD >X014</TD ><TD > </TD ><TD >Attributes of XML type</TD ><TD > </TD ></TR ><TR ><TD >X015</TD ><TD > </TD ><TD >Fields of XML type</TD ><TD > </TD ></TR ><TR ><TD >X025</TD ><TD > </TD ><TD >XMLCast</TD ><TD > </TD ></TR ><TR ><TD >X030</TD ><TD > </TD ><TD >XMLDocument</TD ><TD > </TD ></TR ><TR ><TD >X038</TD ><TD > </TD ><TD >XMLText</TD ><TD > </TD ></TR ><TR ><TD >X065</TD ><TD > </TD ><TD >XMLParse: BLOB input and CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X066</TD ><TD > </TD ><TD >XMLParse: BLOB input and DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X068</TD ><TD > </TD ><TD >XMLSerialize: BOM</TD ><TD > </TD ></TR ><TR ><TD >X069</TD ><TD > </TD ><TD >XMLSerialize: INDENT</TD ><TD > </TD ></TR ><TR ><TD >X073</TD ><TD > </TD ><TD >XMLSerialize: BLOB serialization and CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X074</TD ><TD > </TD ><TD >XMLSerialize: BLOB serialization and DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X075</TD ><TD > </TD ><TD >XMLSerialize: BLOB serialization</TD ><TD > </TD ></TR ><TR ><TD >X076</TD ><TD > </TD ><TD >XMLSerialize: VERSION</TD ><TD > </TD ></TR ><TR ><TD >X077</TD ><TD > </TD ><TD >XMLSerialize: explicit ENCODING option</TD ><TD > </TD ></TR ><TR ><TD >X078</TD ><TD > </TD ><TD >XMLSerialize: explicit XML declaration</TD ><TD > </TD ></TR ><TR ><TD >X080</TD ><TD > </TD ><TD >Namespaces in XML publishing</TD ><TD > </TD ></TR ><TR ><TD >X081</TD ><TD > </TD ><TD >Query-level XML namespace declarations</TD ><TD > </TD ></TR ><TR ><TD >X082</TD ><TD > </TD ><TD >XML namespace declarations in DML</TD ><TD > </TD ></TR ><TR ><TD >X083</TD ><TD > </TD ><TD >XML namespace declarations in DDL</TD ><TD > </TD ></TR ><TR ><TD >X084</TD ><TD > </TD ><TD >XML namespace declarations in compound statements</TD ><TD > </TD ></TR ><TR ><TD >X085</TD ><TD > </TD ><TD >Predefined namespace prefixes</TD ><TD > </TD ></TR ><TR ><TD >X086</TD ><TD > </TD ><TD >XML namespace declarations in XMLTable</TD ><TD > </TD ></TR ><TR ><TD >X091</TD ><TD > </TD ><TD >XML content predicate</TD ><TD > </TD ></TR ><TR ><TD >X096</TD ><TD > </TD ><TD >XMLExists</TD ><TD > </TD ></TR ><TR ><TD >X100</TD ><TD > </TD ><TD >Host language support for XML: CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X101</TD ><TD > </TD ><TD >Host language support for XML: DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X110</TD ><TD > </TD ><TD >Host language support for XML: VARCHAR mapping</TD ><TD > </TD ></TR ><TR ><TD >X111</TD ><TD > </TD ><TD >Host language support for XML: CLOB mapping</TD ><TD > </TD ></TR ><TR ><TD >X112</TD ><TD > </TD ><TD >Host language support for XML: BLOB mapping</TD ><TD > </TD ></TR ><TR ><TD >X113</TD ><TD > </TD ><TD >Host language support for XML: STRIP WHITESPACE option</TD ><TD > </TD ></TR ><TR ><TD >X114</TD ><TD > </TD ><TD >Host language support for XML: PRESERVE WHITESPACE option</TD ><TD > </TD ></TR ><TR ><TD >X131</TD ><TD > </TD ><TD >Query-level XMLBINARY clause</TD ><TD > </TD ></TR ><TR ><TD >X132</TD ><TD > </TD ><TD >XMLBINARY clause in DML</TD ><TD > </TD ></TR ><TR ><TD >X133</TD ><TD > </TD ><TD >XMLBINARY clause in DDL</TD ><TD > </TD ></TR ><TR ><TD >X134</TD ><TD > </TD ><TD >XMLBINARY clause in compound statements</TD ><TD > </TD ></TR ><TR ><TD >X135</TD ><TD > </TD ><TD >XMLBINARY clause in subqueries</TD ><TD > </TD ></TR ><TR ><TD >X141</TD ><TD > </TD ><TD >IS VALID predicate: data-driven case</TD ><TD > </TD ></TR ><TR ><TD >X142</TD ><TD > </TD ><TD >IS VALID predicate: ACCORDING TO clause</TD ><TD > </TD ></TR ><TR ><TD >X143</TD ><TD > </TD ><TD >IS VALID predicate: ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X144</TD ><TD > </TD ><TD >IS VALID predicate: schema location</TD ><TD > </TD ></TR ><TR ><TD >X145</TD ><TD > </TD ><TD >IS VALID predicate outside check constraints</TD ><TD > </TD ></TR ><TR ><TD >X151</TD ><TD > </TD ><TD >IS VALID predicate with DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X152</TD ><TD > </TD ><TD >IS VALID predicate with CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X153</TD ><TD > </TD ><TD >IS VALID predicate with SEQUENCE option</TD ><TD > </TD ></TR ><TR ><TD >X155</TD ><TD > </TD ><TD >IS VALID predicate: NAMESPACE without ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X157</TD ><TD > </TD ><TD >IS VALID predicate: NO NAMESPACE with ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X160</TD ><TD > </TD ><TD >Basic Information Schema for registered XML Schemas</TD ><TD > </TD ></TR ><TR ><TD >X161</TD ><TD > </TD ><TD >Advanced Information Schema for registered XML Schemas</TD ><TD > </TD ></TR ><TR ><TD >X170</TD ><TD > </TD ><TD >XML null handling options</TD ><TD > </TD ></TR ><TR ><TD >X171</TD ><TD > </TD ><TD >NIL ON NO CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X181</TD ><TD > </TD ><TD >XML(DOCUMENT(UNTYPED)) type</TD ><TD > </TD ></TR ><TR ><TD >X182</TD ><TD > </TD ><TD >XML(DOCUMENT(ANY)) type</TD ><TD > </TD ></TR ><TR ><TD >X190</TD ><TD > </TD ><TD >XML(SEQUENCE) type</TD ><TD > </TD ></TR ><TR ><TD >X191</TD ><TD > </TD ><TD >XML(DOCUMENT(XMLSCHEMA)) type</TD ><TD > </TD ></TR ><TR ><TD >X192</TD ><TD > </TD ><TD >XML(CONTENT(XMLSCHEMA)) type</TD ><TD > </TD ></TR ><TR ><TD >X200</TD ><TD > </TD ><TD >XMLQuery</TD ><TD > </TD ></TR ><TR ><TD >X201</TD ><TD > </TD ><TD >XMLQuery: RETURNING CONTENT</TD ><TD > </TD ></TR ><TR ><TD >X202</TD ><TD > </TD ><TD >XMLQuery: RETURNING SEQUENCE</TD ><TD > </TD ></TR ><TR ><TD >X203</TD ><TD > </TD ><TD >XMLQuery: passing a context item</TD ><TD > </TD ></TR ><TR ><TD >X204</TD ><TD > </TD ><TD >XMLQuery: initializing an XQuery variable</TD ><TD > </TD ></TR ><TR ><TD >X205</TD ><TD > </TD ><TD >XMLQuery: EMPTY ON EMPTY option</TD ><TD > </TD ></TR ><TR ><TD >X206</TD ><TD > </TD ><TD >XMLQuery: NULL ON EMPTY option</TD ><TD > </TD ></TR ><TR ><TD >X211</TD ><TD > </TD ><TD >XML 1.1 support</TD ><TD > </TD ></TR ><TR ><TD >X221</TD ><TD > </TD ><TD >XML passing mechanism BY VALUE</TD ><TD > </TD ></TR ><TR ><TD >X222</TD ><TD > </TD ><TD >XML passing mechanism BY REF</TD ><TD > </TD ></TR ><TR ><TD >X231</TD ><TD > </TD ><TD >XML(CONTENT(UNTYPED)) type</TD ><TD > </TD ></TR ><TR ><TD >X232</TD ><TD > </TD ><TD >XML(CONTENT(ANY)) type</TD ><TD > </TD ></TR ><TR ><TD >X241</TD ><TD > </TD ><TD >RETURNING CONTENT in XML publishing</TD ><TD > </TD ></TR ><TR ><TD >X242</TD ><TD > </TD ><TD >RETURNING SEQUENCE in XML publishing</TD ><TD > </TD ></TR ><TR ><TD >X251</TD ><TD > </TD ><TD >Persistent XML values of XML(DOCUMENT(UNTYPED)) type</TD ><TD > </TD ></TR ><TR ><TD >X252</TD ><TD > </TD ><TD >Persistent XML values of XML(DOCUMENT(ANY)) type</TD ><TD > </TD ></TR ><TR ><TD >X253</TD ><TD > </TD ><TD >Persistent XML values of XML(CONTENT(UNTYPED)) type</TD ><TD > </TD ></TR ><TR ><TD >X254</TD ><TD > </TD ><TD >Persistent XML values of XML(CONTENT(ANY)) type</TD ><TD > </TD ></TR ><TR ><TD >X255</TD ><TD > </TD ><TD >Persistent XML values of XML(SEQUENCE) type</TD ><TD > </TD ></TR ><TR ><TD >X256</TD ><TD > </TD ><TD >Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type</TD ><TD > </TD ></TR ><TR ><TD >X257</TD ><TD > </TD ><TD >Persistent XML values of XML(CONTENT(XMLSCHEMA)) type</TD ><TD > </TD ></TR ><TR ><TD >X260</TD ><TD > </TD ><TD >XML type: ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X261</TD ><TD > </TD ><TD >XML type: NAMESPACE without ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X263</TD ><TD > </TD ><TD >XML type: NO NAMESPACE with ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X264</TD ><TD > </TD ><TD >XML type: schema location</TD ><TD > </TD ></TR ><TR ><TD >X271</TD ><TD > </TD ><TD >XMLValidate: data-driven case</TD ><TD > </TD ></TR ><TR ><TD >X272</TD ><TD > </TD ><TD >XMLValidate: ACCORDING TO clause</TD ><TD > </TD ></TR ><TR ><TD >X273</TD ><TD > </TD ><TD >XMLValidate: ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X274</TD ><TD > </TD ><TD >XMLValidate: schema location</TD ><TD > </TD ></TR ><TR ><TD >X281</TD ><TD > </TD ><TD >XMLValidate: with DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X282</TD ><TD > </TD ><TD >XMLValidate with CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X283</TD ><TD > </TD ><TD >XMLValidate with SEQUENCE option</TD ><TD > </TD ></TR ><TR ><TD >X284</TD ><TD > </TD ><TD >XMLValidate NAMESPACE without ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X286</TD ><TD > </TD ><TD >XMLValidate: NO NAMESPACE with ELEMENT clause</TD ><TD > </TD ></TR ><TR ><TD >X300</TD ><TD > </TD ><TD >XMLTable</TD ><TD > </TD ></TR ><TR ><TD >X301</TD ><TD > </TD ><TD >XMLTable: derived column list option</TD ><TD > </TD ></TR ><TR ><TD >X302</TD ><TD > </TD ><TD >XMLTable: ordinality column option</TD ><TD > </TD ></TR ><TR ><TD >X303</TD ><TD > </TD ><TD >XMLTable: column default option</TD ><TD > </TD ></TR ><TR ><TD >X304</TD ><TD > </TD ><TD >XMLTable: passing a context item</TD ><TD > </TD ></TR ><TR ><TD >X305</TD ><TD > </TD ><TD >XMLTable: initializing an XQuery variable</TD ><TD > </TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="features-sql-standard.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="release.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Supported Features</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="features.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Release Notes</TD ></TR ></TABLE ></DIV ></BODY ></HTML >
修改文件时间
将文件时间修改为当前时间的前一年
删除文件