<!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 8.3.6 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="2009-02-03T04:34:16"></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"
>PostgreSQL 8.3.6 Documentation</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="features-sql-standard.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="features.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Appendix D. SQL Conformance</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="features.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
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:2003</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="AEN84632"
></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
>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
>C011</TD
><TD
>Core</TD
><TD
>Call-Level Interface</TD
><TD
> </TD
></TR
><TR
><TD
>E081</TD
><TD
>Core</TD
><TD
>Basic Privileges</TD
><TD
> </TD
></TR
><TR
><TD
>E081-05</TD
><TD
>Core</TD
><TD
>UPDATE privilege at the column level</TD
><TD
> </TD
></TR
><TR
><TD
>E081-07</TD
><TD
>Core</TD
><TD
>REFERENCES privilege at the column level</TD
><TD
> </TD
></TR
><TR
><TD
>E081-09</TD
><TD
>Core</TD
><TD
>USAGE privilege</TD
><TD
> </TD
></TR
><TR
><TD
>E121</TD
><TD
>Core</TD
><TD
>Basic cursor support</TD
><TD
> </TD
></TR
><TR
><TD
>E121-06</TD
><TD
>Core</TD
><TD
>Positioned UPDATE statement</TD
><TD
> </TD
></TR
><TR
><TD
>E121-07</TD
><TD
>Core</TD
><TD
>Positioned DELETE statement</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
>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
>F181</TD
><TD
>Core</TD
><TD
>Multiple module support</TD
><TD
> </TD
></TR
><TR
><TD
>F262</TD
><TD
> </TD
><TD
>Extended CASE expression</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
>F341</TD
><TD
> </TD
><TD
>Usage tables</TD
><TD
> </TD
></TR
><TR
><TD
>F392</TD
><TD
> </TD
><TD
>Unicode escapes in identifiers</TD
><TD
> </TD
></TR
><TR
><TD
>F393</TD
><TD
> </TD
><TD
>Unicode escapes in literals</TD
><TD
> </TD
></TR
><TR
><TD
>F402</TD
><TD
> </TD
><TD
>Named column joins for LOBs, arrays, and multisets</TD
><TD
> </TD
></TR
><TR
><TD
>F442</TD
><TD
> </TD
><TD
>Mixed column references in set functions</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
>F521</TD
><TD
>Enhanced integrity management</TD
><TD
>Assertions</TD
><TD
> </TD
></TR
><TR
><TD
>F641</TD
><TD
> </TD
><TD
>Row and table constructors</TD
><TD
> </TD
></TR
><TR
><TD
>F661</TD
><TD
> </TD
><TD
>Simple tables</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
>F691</TD
><TD
> </TD
><TD
>Collation and translation</TD
><TD
> </TD
></TR
><TR
><TD
>F692</TD
><TD
> </TD
><TD
>Enhanced collation support</TD
><TD
> </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 keys only</TD
></TR
><TR
><TD
>F731</TD
><TD
> </TD
><TD
>INSERT column privileges</TD
><TD
> </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
>F811</TD
><TD
> </TD
><TD
>Extended flagging</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
>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
> </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
> </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
>S092</TD
><TD
> </TD
><TD
>Arrays of user-defined types</TD
><TD
> </TD
></TR
><TR
><TD
>S094</TD
><TD
> </TD
><TD
>Arrays of reference types</TD
><TD
> </TD
></TR
><TR
><TD
>S095</TD
><TD
> </TD
><TD
>Array constructors by query</TD
><TD
> </TD
></TR
><TR
><TD
>S096</TD
><TD
> </TD
><TD
>Optional array bounds</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
>S201</TD
><TD
> </TD
><TD
>SQL-invoked routines on arrays</TD
><TD
> </TD
></TR
><TR
><TD
>S201-01</TD
><TD
> </TD
><TD
>Array parameters</TD
><TD
> </TD
></TR
><TR
><TD
>S201-02</TD
><TD
> </TD
><TD
>Array as result type of functions</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
>T011</TD
><TD
> </TD
><TD
>Timestamp in Information Schema</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
>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
>T111</TD
><TD
> </TD
><TD
>Updatable joins, unions, and columns</TD
><TD
> </TD
></TR
><TR
><TD
>T121</TD
><TD
> </TD
><TD
>WITH (excluding RECURSIVE) in query expression</TD
><TD
> </TD
></TR
><TR
><TD
>T122</TD
><TD
> </TD
><TD
>WITH (excluding RECURSIVE) in subquery</TD
><TD
> </TD
></TR
><TR
><TD
>T131</TD
><TD
> </TD
><TD
>Recursive query</TD
><TD
> </TD
></TR
><TR
><TD
>T132</TD
><TD
> </TD
><TD
>Recursive query in subquery</TD
><TD
> </TD
></TR
><TR
><TD
>T152</TD
><TD
> </TD
><TD
>DISTINCT predicate with negation</TD
><TD
> </TD
></TR
><TR
><TD
>T172</TD
><TD
> </TD
><TD
>AS subquery clause in table definition</TD
><TD
> </TD
></TR
><TR
><TD
>T173</TD
><TD
> </TD
><TD
>Extended LIKE clause in table definition</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
>T211</TD
><TD
>Active database, Enhanced integrity management</TD
><TD
>Basic trigger capability</TD
><TD
> </TD
></TR
><TR
><TD
>T211-05</TD
><TD
>Active database, Enhanced integrity management</TD
><TD
>Ability to specify a search condition that must be true before the trigger is invoked</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
>T281</TD
><TD
> </TD
><TD
>SELECT privilege with column granularity</TD
><TD
> </TD
></TR
><TR
><TD
>T301</TD
><TD
> </TD
><TD
>Functional dependencies</TD
><TD
> </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
>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
>T331</TD
><TD
> </TD
><TD
>Basic roles</TD
><TD
> </TD
></TR
><TR
><TD
>T332</TD
><TD
> </TD
><TD
>Extended roles</TD
><TD
> </TD
></TR
><TR
><TD
>T401</TD
><TD
> </TD
><TD
>INSERT into a cursor</TD
><TD
> </TD
></TR
><TR
><TD
>T411</TD
><TD
> </TD
><TD
>UPDATE statement: SET ROW option</TD
><TD
> </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
>T491</TD
><TD
> </TD
><TD
>LATERAL derived table</TD
><TD
> </TD
></TR
><TR
><TD
>T511</TD
><TD
> </TD
><TD
>Transaction counts</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
> </TD
></TR
><TR
><TD
>T612</TD
><TD
> </TD
><TD
>Advanced OLAP operations</TD
><TD
> </TD
></TR
><TR
><TD
>T613</TD
><TD
> </TD
><TD
>Sampling</TD
><TD
> </TD
></TR
><TR
><TD
>T621</TD
><TD
> </TD
><TD
>Enhanced numeric functions</TD
><TD
> </TD
></TR
><TR
><TD
>T631</TD
><TD
>Core</TD
><TD
>IN predicate with one list element</TD
><TD
> </TD
></TR
><TR
><TD
>T641</TD
><TD
> </TD
><TD
>Multiple column assignment</TD
><TD
> </TD
></TR
><TR
><TD
>T651</TD
><TD
> </TD
><TD
>SQL-schema statements in SQL routines</TD
><TD
> </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
>T655</TD
><TD
> </TD
><TD
>Cyclically dependent 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
>X035</TD
><TD
> </TD
><TD
>XMLAgg: ORDER BY option</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
>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
>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
></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
>
Mandriva
>
2008.1
>
x86_64
>
media
>
main-testing
>
by-pkgid
>
bab02a23fa9f3df8d66a9a3231b50245
>
files
>
889
