<!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.4.15 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-10T00:43:05"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="4"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.4.15 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="AEN117779"
></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
>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
>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
>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
>ARRAY_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
>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
>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
>different API</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
>different API</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
>
distrib
>
Mageia
>
6
>
armv7hl
>
media
>
core-updates
>
by-pkgid
>
a8985c53237f42e0cfdfd17da0a53df3
>
files
>
1250
