<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Supported 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.8 Documentation" HREF="index.html"><LINK REL="UP" TITLE="SQL Conformance" HREF="features.html"><LINK REL="PREVIOUS" TITLE="SQL Conformance" HREF="features.html"><LINK REL="NEXT" TITLE="Unsupported Features" HREF="unsupported-features-sql-standard.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-09-04T05:13:45"></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.8 Documentation</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="features.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="unsupported-features-sql-standard.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="FEATURES-SQL-STANDARD" >D.1. Supported Features</A ></H1 ><P > <DIV CLASS="INFORMALTABLE" ><P ></P ><A NAME="AEN83163" ></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 >B012</TD ><TD > </TD ><TD >Embedded C</TD ><TD > </TD ></TR ><TR ><TD >B021</TD ><TD > </TD ><TD >Direct SQL</TD ><TD > </TD ></TR ><TR ><TD >E011</TD ><TD >Core</TD ><TD >Numeric data types</TD ><TD > </TD ></TR ><TR ><TD >E011-01</TD ><TD >Core</TD ><TD >INTEGER and SMALLINT data types</TD ><TD > </TD ></TR ><TR ><TD >E011-02</TD ><TD >Core</TD ><TD >REAL, DOUBLE PRECISION, and FLOAT data types</TD ><TD > </TD ></TR ><TR ><TD >E011-03</TD ><TD >Core</TD ><TD >DECIMAL and NUMERIC data types</TD ><TD > </TD ></TR ><TR ><TD >E011-04</TD ><TD >Core</TD ><TD >Arithmetic operators</TD ><TD > </TD ></TR ><TR ><TD >E011-05</TD ><TD >Core</TD ><TD >Numeric comparison</TD ><TD > </TD ></TR ><TR ><TD >E011-06</TD ><TD >Core</TD ><TD >Implicit casting among the numeric data types</TD ><TD > </TD ></TR ><TR ><TD >E021</TD ><TD >Core</TD ><TD >Character data types</TD ><TD > </TD ></TR ><TR ><TD >E021-01</TD ><TD >Core</TD ><TD >CHARACTER data type</TD ><TD > </TD ></TR ><TR ><TD >E021-02</TD ><TD >Core</TD ><TD >CHARACTER VARYING data type</TD ><TD > </TD ></TR ><TR ><TD >E021-03</TD ><TD >Core</TD ><TD >Character literals</TD ><TD > </TD ></TR ><TR ><TD >E021-04</TD ><TD >Core</TD ><TD >CHARACTER_LENGTH function</TD ><TD >trims trailing spaces from CHARACTER values before counting</TD ></TR ><TR ><TD >E021-05</TD ><TD >Core</TD ><TD >OCTET_LENGTH function</TD ><TD > </TD ></TR ><TR ><TD >E021-06</TD ><TD >Core</TD ><TD >SUBSTRING function</TD ><TD > </TD ></TR ><TR ><TD >E021-07</TD ><TD >Core</TD ><TD >Character concatenation</TD ><TD > </TD ></TR ><TR ><TD >E021-08</TD ><TD >Core</TD ><TD >UPPER and LOWER functions</TD ><TD > </TD ></TR ><TR ><TD >E021-09</TD ><TD >Core</TD ><TD >TRIM function</TD ><TD > </TD ></TR ><TR ><TD >E021-10</TD ><TD >Core</TD ><TD >Implicit casting among the character string types</TD ><TD > </TD ></TR ><TR ><TD >E021-11</TD ><TD >Core</TD ><TD >POSITION function</TD ><TD > </TD ></TR ><TR ><TD >E021-12</TD ><TD >Core</TD ><TD >Character comparison</TD ><TD > </TD ></TR ><TR ><TD >E031</TD ><TD >Core</TD ><TD >Identifiers</TD ><TD > </TD ></TR ><TR ><TD >E031-01</TD ><TD >Core</TD ><TD >Delimited identifiers</TD ><TD > </TD ></TR ><TR ><TD >E031-02</TD ><TD >Core</TD ><TD >Lower case identifiers</TD ><TD > </TD ></TR ><TR ><TD >E031-03</TD ><TD >Core</TD ><TD >Trailing underscore</TD ><TD > </TD ></TR ><TR ><TD >E051</TD ><TD >Core</TD ><TD >Basic query specification</TD ><TD > </TD ></TR ><TR ><TD >E051-01</TD ><TD >Core</TD ><TD >SELECT DISTINCT</TD ><TD > </TD ></TR ><TR ><TD >E051-02</TD ><TD >Core</TD ><TD >GROUP BY clause</TD ><TD > </TD ></TR ><TR ><TD >E051-04</TD ><TD >Core</TD ><TD >GROUP BY can contain columns not in <select list></TD ><TD > </TD ></TR ><TR ><TD >E051-05</TD ><TD >Core</TD ><TD >Select list items can be renamed</TD ><TD >AS is required</TD ></TR ><TR ><TD >E051-06</TD ><TD >Core</TD ><TD >HAVING clause</TD ><TD > </TD ></TR ><TR ><TD >E051-07</TD ><TD >Core</TD ><TD >Qualified * in select list</TD ><TD > </TD ></TR ><TR ><TD >E051-08</TD ><TD >Core</TD ><TD >Correlation names in the FROM clause</TD ><TD > </TD ></TR ><TR ><TD >E051-09</TD ><TD >Core</TD ><TD >Rename columns in the FROM clause</TD ><TD > </TD ></TR ><TR ><TD >E061</TD ><TD >Core</TD ><TD >Basic predicates and search conditions</TD ><TD > </TD ></TR ><TR ><TD >E061-01</TD ><TD >Core</TD ><TD >Comparison predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-02</TD ><TD >Core</TD ><TD >BETWEEN predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-03</TD ><TD >Core</TD ><TD >IN predicate with list of values</TD ><TD > </TD ></TR ><TR ><TD >E061-04</TD ><TD >Core</TD ><TD >LIKE predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-05</TD ><TD >Core</TD ><TD >LIKE predicate ESCAPE clause</TD ><TD > </TD ></TR ><TR ><TD >E061-06</TD ><TD >Core</TD ><TD >NULL predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-07</TD ><TD >Core</TD ><TD >Quantified comparison predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-08</TD ><TD >Core</TD ><TD >EXISTS predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-09</TD ><TD >Core</TD ><TD >Subqueries in comparison predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-11</TD ><TD >Core</TD ><TD >Subqueries in IN predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-12</TD ><TD >Core</TD ><TD >Subqueries in quantified comparison predicate</TD ><TD > </TD ></TR ><TR ><TD >E061-13</TD ><TD >Core</TD ><TD >Correlated subqueries</TD ><TD > </TD ></TR ><TR ><TD >E061-14</TD ><TD >Core</TD ><TD >Search condition</TD ><TD > </TD ></TR ><TR ><TD >E071</TD ><TD >Core</TD ><TD >Basic query expressions</TD ><TD > </TD ></TR ><TR ><TD >E071-01</TD ><TD >Core</TD ><TD >UNION DISTINCT table operator</TD ><TD > </TD ></TR ><TR ><TD >E071-02</TD ><TD >Core</TD ><TD >UNION ALL table operator</TD ><TD > </TD ></TR ><TR ><TD >E071-03</TD ><TD >Core</TD ><TD >EXCEPT DISTINCT table operator</TD ><TD > </TD ></TR ><TR ><TD >E071-05</TD ><TD >Core</TD ><TD >Columns combined via table operators need not have exactly the same data type</TD ><TD > </TD ></TR ><TR ><TD >E071-06</TD ><TD >Core</TD ><TD >Table operators in subqueries</TD ><TD > </TD ></TR ><TR ><TD >E081-01</TD ><TD >Core</TD ><TD >SELECT privilege</TD ><TD > </TD ></TR ><TR ><TD >E081-02</TD ><TD >Core</TD ><TD >DELETE privilege</TD ><TD > </TD ></TR ><TR ><TD >E081-03</TD ><TD >Core</TD ><TD >INSERT privilege at the table level</TD ><TD > </TD ></TR ><TR ><TD >E081-04</TD ><TD >Core</TD ><TD >UPDATE privilege at the table level</TD ><TD > </TD ></TR ><TR ><TD >E081-06</TD ><TD >Core</TD ><TD >REFERENCES privilege at the table level</TD ><TD > </TD ></TR ><TR ><TD >E081-08</TD ><TD >Core</TD ><TD >WITH GRANT OPTION</TD ><TD > </TD ></TR ><TR ><TD >E081-10</TD ><TD >Core</TD ><TD >EXECUTE privilege</TD ><TD > </TD ></TR ><TR ><TD >E091</TD ><TD >Core</TD ><TD >Set functions</TD ><TD > </TD ></TR ><TR ><TD >E091-01</TD ><TD >Core</TD ><TD >AVG</TD ><TD > </TD ></TR ><TR ><TD >E091-02</TD ><TD >Core</TD ><TD >COUNT</TD ><TD > </TD ></TR ><TR ><TD >E091-03</TD ><TD >Core</TD ><TD >MAX</TD ><TD > </TD ></TR ><TR ><TD >E091-04</TD ><TD >Core</TD ><TD >MIN</TD ><TD > </TD ></TR ><TR ><TD >E091-05</TD ><TD >Core</TD ><TD >SUM</TD ><TD > </TD ></TR ><TR ><TD >E091-06</TD ><TD >Core</TD ><TD >ALL quantifier</TD ><TD > </TD ></TR ><TR ><TD >E091-07</TD ><TD >Core</TD ><TD >DISTINCT quantifier</TD ><TD > </TD ></TR ><TR ><TD >E101</TD ><TD >Core</TD ><TD >Basic data manipulation</TD ><TD > </TD ></TR ><TR ><TD >E101-01</TD ><TD >Core</TD ><TD >INSERT statement</TD ><TD > </TD ></TR ><TR ><TD >E101-03</TD ><TD >Core</TD ><TD >Searched UPDATE statement</TD ><TD > </TD ></TR ><TR ><TD >E101-04</TD ><TD >Core</TD ><TD >Searched DELETE statement</TD ><TD > </TD ></TR ><TR ><TD >E111</TD ><TD >Core</TD ><TD >Single row SELECT statement</TD ><TD > </TD ></TR ><TR ><TD >E121-01</TD ><TD >Core</TD ><TD >DECLARE CURSOR</TD ><TD > </TD ></TR ><TR ><TD >E121-02</TD ><TD >Core</TD ><TD >ORDER BY columns need not be in select list</TD ><TD > </TD ></TR ><TR ><TD >E121-03</TD ><TD >Core</TD ><TD >Value expressions in ORDER BY clause</TD ><TD > </TD ></TR ><TR ><TD >E121-04</TD ><TD >Core</TD ><TD >OPEN statement</TD ><TD > </TD ></TR ><TR ><TD >E121-08</TD ><TD >Core</TD ><TD >CLOSE statement</TD ><TD > </TD ></TR ><TR ><TD >E121-10</TD ><TD >Core</TD ><TD >FETCH statement implicit NEXT</TD ><TD > </TD ></TR ><TR ><TD >E121-17</TD ><TD >Core</TD ><TD >WITH HOLD cursors</TD ><TD > </TD ></TR ><TR ><TD >E131</TD ><TD >Core</TD ><TD >Null value support (nulls in lieu of values)</TD ><TD > </TD ></TR ><TR ><TD >E141</TD ><TD >Core</TD ><TD >Basic integrity constraints</TD ><TD > </TD ></TR ><TR ><TD >E141-01</TD ><TD >Core</TD ><TD >NOT NULL constraints</TD ><TD > </TD ></TR ><TR ><TD >E141-02</TD ><TD >Core</TD ><TD >UNIQUE constraints of NOT NULL columns</TD ><TD > </TD ></TR ><TR ><TD >E141-03</TD ><TD >Core</TD ><TD >PRIMARY KEY constraints</TD ><TD > </TD ></TR ><TR ><TD >E141-04</TD ><TD >Core</TD ><TD >Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action</TD ><TD > </TD ></TR ><TR ><TD >E141-06</TD ><TD >Core</TD ><TD >CHECK constraints</TD ><TD > </TD ></TR ><TR ><TD >E141-07</TD ><TD >Core</TD ><TD >Column defaults</TD ><TD > </TD ></TR ><TR ><TD >E141-08</TD ><TD >Core</TD ><TD >NOT NULL inferred on PRIMARY KEY</TD ><TD > </TD ></TR ><TR ><TD >E141-10</TD ><TD >Core</TD ><TD >Names in a foreign key can be specified in any order</TD ><TD > </TD ></TR ><TR ><TD >E151</TD ><TD >Core</TD ><TD >Transaction support</TD ><TD > </TD ></TR ><TR ><TD >E151-01</TD ><TD >Core</TD ><TD >COMMIT statement</TD ><TD > </TD ></TR ><TR ><TD >E151-02</TD ><TD >Core</TD ><TD >ROLLBACK statement</TD ><TD > </TD ></TR ><TR ><TD >E152</TD ><TD >Core</TD ><TD >Basic SET TRANSACTION statement</TD ><TD > </TD ></TR ><TR ><TD >E152-01</TD ><TD >Core</TD ><TD >SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause</TD ><TD > </TD ></TR ><TR ><TD >E152-02</TD ><TD >Core</TD ><TD >SET TRANSACTION statement: READ ONLY and READ WRITE clauses</TD ><TD > </TD ></TR ><TR ><TD >E161</TD ><TD >Core</TD ><TD >SQL comments using leading double minus</TD ><TD > </TD ></TR ><TR ><TD >E171</TD ><TD >Core</TD ><TD >SQLSTATE support</TD ><TD > </TD ></TR ><TR ><TD >F021</TD ><TD >Core</TD ><TD >Basic information schema</TD ><TD > </TD ></TR ><TR ><TD >F021-01</TD ><TD >Core</TD ><TD >COLUMNS view</TD ><TD > </TD ></TR ><TR ><TD >F021-02</TD ><TD >Core</TD ><TD >TABLES view</TD ><TD > </TD ></TR ><TR ><TD >F021-03</TD ><TD >Core</TD ><TD >VIEWS view</TD ><TD > </TD ></TR ><TR ><TD >F021-04</TD ><TD >Core</TD ><TD >TABLE_CONSTRAINTS view</TD ><TD > </TD ></TR ><TR ><TD >F021-05</TD ><TD >Core</TD ><TD >REFERENTIAL_CONSTRAINTS view</TD ><TD > </TD ></TR ><TR ><TD >F021-06</TD ><TD >Core</TD ><TD >CHECK_CONSTRAINTS view</TD ><TD > </TD ></TR ><TR ><TD >F031</TD ><TD >Core</TD ><TD >Basic schema manipulation</TD ><TD > </TD ></TR ><TR ><TD >F031-01</TD ><TD >Core</TD ><TD >CREATE TABLE statement to create persistent base tables</TD ><TD > </TD ></TR ><TR ><TD >F031-02</TD ><TD >Core</TD ><TD >CREATE VIEW statement</TD ><TD > </TD ></TR ><TR ><TD >F031-03</TD ><TD >Core</TD ><TD >GRANT statement</TD ><TD > </TD ></TR ><TR ><TD >F031-04</TD ><TD >Core</TD ><TD >ALTER TABLE statement: ADD COLUMN clause</TD ><TD > </TD ></TR ><TR ><TD >F031-13</TD ><TD >Core</TD ><TD >DROP TABLE statement: RESTRICT clause</TD ><TD > </TD ></TR ><TR ><TD >F031-16</TD ><TD >Core</TD ><TD >DROP VIEW statement: RESTRICT clause</TD ><TD > </TD ></TR ><TR ><TD >F031-19</TD ><TD >Core</TD ><TD >REVOKE statement: RESTRICT clause</TD ><TD > </TD ></TR ><TR ><TD >F032</TD ><TD > </TD ><TD >CASCADE drop behavior</TD ><TD > </TD ></TR ><TR ><TD >F033</TD ><TD > </TD ><TD >ALTER TABLE statement: DROP COLUMN clause</TD ><TD > </TD ></TR ><TR ><TD >F034</TD ><TD > </TD ><TD >Extended REVOKE statement</TD ><TD > </TD ></TR ><TR ><TD >F034-01</TD ><TD > </TD ><TD >REVOKE statement performed by other than the owner of a schema object</TD ><TD > </TD ></TR ><TR ><TD >F034-02</TD ><TD > </TD ><TD >REVOKE statement: GRANT OPTION FOR clause</TD ><TD > </TD ></TR ><TR ><TD >F034-03</TD ><TD > </TD ><TD >REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION</TD ><TD > </TD ></TR ><TR ><TD >F041</TD ><TD >Core</TD ><TD >Basic joined table</TD ><TD > </TD ></TR ><TR ><TD >F041-01</TD ><TD >Core</TD ><TD >Inner join (but not necessarily the INNER keyword)</TD ><TD > </TD ></TR ><TR ><TD >F041-02</TD ><TD >Core</TD ><TD >INNER keyword</TD ><TD > </TD ></TR ><TR ><TD >F041-03</TD ><TD >Core</TD ><TD >LEFT OUTER JOIN</TD ><TD > </TD ></TR ><TR ><TD >F041-04</TD ><TD >Core</TD ><TD >RIGHT OUTER JOIN</TD ><TD > </TD ></TR ><TR ><TD >F041-05</TD ><TD >Core</TD ><TD >Outer joins can be nested</TD ><TD > </TD ></TR ><TR ><TD >F041-07</TD ><TD >Core</TD ><TD >The inner table in a left or right outer join can also be used in an inner join</TD ><TD > </TD ></TR ><TR ><TD >F041-08</TD ><TD >Core</TD ><TD >All comparison operators are supported (rather than just =)</TD ><TD > </TD ></TR ><TR ><TD >F051</TD ><TD >Core</TD ><TD >Basic date and time</TD ><TD > </TD ></TR ><TR ><TD >F051-01</TD ><TD >Core</TD ><TD >DATE data type (including support of DATE literal)</TD ><TD > </TD ></TR ><TR ><TD >F051-02</TD ><TD >Core</TD ><TD >TIME data type (including support of TIME literal) with fractional seconds precision of at least 0</TD ><TD > </TD ></TR ><TR ><TD >F051-03</TD ><TD >Core</TD ><TD >TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6</TD ><TD > </TD ></TR ><TR ><TD >F051-04</TD ><TD >Core</TD ><TD >Comparison predicate on DATE, TIME, and TIMESTAMP data types</TD ><TD > </TD ></TR ><TR ><TD >F051-05</TD ><TD >Core</TD ><TD >Explicit CAST between datetime types and character string types</TD ><TD > </TD ></TR ><TR ><TD >F051-06</TD ><TD >Core</TD ><TD >CURRENT_DATE</TD ><TD > </TD ></TR ><TR ><TD >F051-07</TD ><TD >Core</TD ><TD >LOCALTIME</TD ><TD > </TD ></TR ><TR ><TD >F051-08</TD ><TD >Core</TD ><TD >LOCALTIMESTAMP</TD ><TD > </TD ></TR ><TR ><TD >F052</TD ><TD >Enhanced datetime facilities</TD ><TD >Intervals and datetime arithmetic</TD ><TD > </TD ></TR ><TR ><TD >F053</TD ><TD > </TD ><TD >OVERLAPS predicate</TD ><TD > </TD ></TR ><TR ><TD >F081</TD ><TD >Core</TD ><TD >UNION and EXCEPT in views</TD ><TD > </TD ></TR ><TR ><TD >F111</TD ><TD > </TD ><TD >Isolation levels other than SERIALIZABLE</TD ><TD > </TD ></TR ><TR ><TD >F111-01</TD ><TD > </TD ><TD >READ UNCOMMITTED isolation level</TD ><TD > </TD ></TR ><TR ><TD >F111-02</TD ><TD > </TD ><TD >READ COMMITTED isolation level</TD ><TD > </TD ></TR ><TR ><TD >F111-03</TD ><TD > </TD ><TD >REPEATABLE READ isolation level</TD ><TD > </TD ></TR ><TR ><TD >F131</TD ><TD >Core</TD ><TD >Grouped operations</TD ><TD > </TD ></TR ><TR ><TD >F131-01</TD ><TD >Core</TD ><TD >WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views</TD ><TD > </TD ></TR ><TR ><TD >F131-02</TD ><TD >Core</TD ><TD >Multiple tables supported in queries with grouped views</TD ><TD > </TD ></TR ><TR ><TD >F131-03</TD ><TD >Core</TD ><TD >Set functions supported in queries with grouped views</TD ><TD > </TD ></TR ><TR ><TD >F131-04</TD ><TD >Core</TD ><TD >Subqueries with GROUP BY and HAVING clauses and grouped views</TD ><TD > </TD ></TR ><TR ><TD >F131-05</TD ><TD >Core</TD ><TD >Single row SELECT with GROUP BY and HAVING clauses and grouped views</TD ><TD > </TD ></TR ><TR ><TD >F171</TD ><TD > </TD ><TD >Multiple schemas per user</TD ><TD > </TD ></TR ><TR ><TD >F191</TD ><TD >Enhanced integrity management</TD ><TD >Referential delete actions</TD ><TD > </TD ></TR ><TR ><TD >F201</TD ><TD >Core</TD ><TD >CAST function</TD ><TD > </TD ></TR ><TR ><TD >F221</TD ><TD >Core</TD ><TD >Explicit defaults</TD ><TD > </TD ></TR ><TR ><TD >F222</TD ><TD > </TD ><TD >INSERT statement: DEFAULT VALUES clause</TD ><TD > </TD ></TR ><TR ><TD >F231</TD ><TD > </TD ><TD >Privilege tables</TD ><TD > </TD ></TR ><TR ><TD >F231-01</TD ><TD > </TD ><TD >TABLE_PRIVILEGES view</TD ><TD > </TD ></TR ><TR ><TD >F231-02</TD ><TD > </TD ><TD >COLUMN_PRIVILEGES view</TD ><TD > </TD ></TR ><TR ><TD >F231-03</TD ><TD > </TD ><TD >USAGE_PRIVILEGES view</TD ><TD > </TD ></TR ><TR ><TD >F251</TD ><TD > </TD ><TD >Domain support</TD ><TD > </TD ></TR ><TR ><TD >F261</TD ><TD >Core</TD ><TD >CASE expression</TD ><TD > </TD ></TR ><TR ><TD >F261-01</TD ><TD >Core</TD ><TD >Simple CASE</TD ><TD > </TD ></TR ><TR ><TD >F261-02</TD ><TD >Core</TD ><TD >Searched CASE</TD ><TD > </TD ></TR ><TR ><TD >F261-03</TD ><TD >Core</TD ><TD >NULLIF</TD ><TD > </TD ></TR ><TR ><TD >F261-04</TD ><TD >Core</TD ><TD >COALESCE</TD ><TD > </TD ></TR ><TR ><TD >F271</TD ><TD > </TD ><TD >Compound character literals</TD ><TD > </TD ></TR ><TR ><TD >F281</TD ><TD > </TD ><TD >LIKE enhancements</TD ><TD > </TD ></TR ><TR ><TD >F302</TD ><TD > </TD ><TD >INTERSECT table operator</TD ><TD > </TD ></TR ><TR ><TD >F302-01</TD ><TD > </TD ><TD >INTERSECT DISTINCT table operator</TD ><TD > </TD ></TR ><TR ><TD >F302-02</TD ><TD > </TD ><TD >INTERSECT ALL table operator</TD ><TD > </TD ></TR ><TR ><TD >F304</TD ><TD > </TD ><TD >EXCEPT ALL table operator</TD ><TD > </TD ></TR ><TR ><TD >F311-01</TD ><TD >Core</TD ><TD >CREATE SCHEMA</TD ><TD > </TD ></TR ><TR ><TD >F311-02</TD ><TD >Core</TD ><TD >CREATE TABLE for persistent base tables</TD ><TD > </TD ></TR ><TR ><TD >F311-03</TD ><TD >Core</TD ><TD >CREATE VIEW</TD ><TD > </TD ></TR ><TR ><TD >F311-05</TD ><TD >Core</TD ><TD >GRANT statement</TD ><TD > </TD ></TR ><TR ><TD >F321</TD ><TD > </TD ><TD >User authorization</TD ><TD > </TD ></TR ><TR ><TD >F361</TD ><TD > </TD ><TD >Subprogram support</TD ><TD > </TD ></TR ><TR ><TD >F381</TD ><TD > </TD ><TD >Extended schema manipulation</TD ><TD > </TD ></TR ><TR ><TD >F381-01</TD ><TD > </TD ><TD >ALTER TABLE statement: ALTER COLUMN clause</TD ><TD > </TD ></TR ><TR ><TD >F381-02</TD ><TD > </TD ><TD >ALTER TABLE statement: ADD CONSTRAINT clause</TD ><TD > </TD ></TR ><TR ><TD >F381-03</TD ><TD > </TD ><TD >ALTER TABLE statement: DROP CONSTRAINT clause</TD ><TD > </TD ></TR ><TR ><TD >F391</TD ><TD > </TD ><TD >Long identifiers</TD ><TD > </TD ></TR ><TR ><TD >F401</TD ><TD > </TD ><TD >Extended joined table</TD ><TD > </TD ></TR ><TR ><TD >F401-01</TD ><TD > </TD ><TD >NATURAL JOIN</TD ><TD > </TD ></TR ><TR ><TD >F401-02</TD ><TD > </TD ><TD >FULL OUTER JOIN</TD ><TD > </TD ></TR ><TR ><TD >F401-04</TD ><TD > </TD ><TD >CROSS JOIN</TD ><TD > </TD ></TR ><TR ><TD >F411</TD ><TD >Enhanced datetime facilities</TD ><TD >Time zone specification</TD ><TD >differences regarding literal interpretation</TD ></TR ><TR ><TD >F421</TD ><TD > </TD ><TD >National character</TD ><TD > </TD ></TR ><TR ><TD >F431</TD ><TD > </TD ><TD >Read-only scrollable cursors</TD ><TD > </TD ></TR ><TR ><TD >F431-01</TD ><TD > </TD ><TD >FETCH with explicit NEXT</TD ><TD > </TD ></TR ><TR ><TD >F431-02</TD ><TD > </TD ><TD >FETCH FIRST</TD ><TD > </TD ></TR ><TR ><TD >F431-03</TD ><TD > </TD ><TD >FETCH LAST</TD ><TD > </TD ></TR ><TR ><TD >F431-04</TD ><TD > </TD ><TD >FETCH PRIOR</TD ><TD > </TD ></TR ><TR ><TD >F431-05</TD ><TD > </TD ><TD >FETCH ABSOLUTE</TD ><TD > </TD ></TR ><TR ><TD >F431-06</TD ><TD > </TD ><TD >FETCH RELATIVE</TD ><TD > </TD ></TR ><TR ><TD >F441</TD ><TD > </TD ><TD >Extended set function support</TD ><TD > </TD ></TR ><TR ><TD >F471</TD ><TD >Core</TD ><TD >Scalar subquery values</TD ><TD > </TD ></TR ><TR ><TD >F481</TD ><TD >Core</TD ><TD >Expanded NULL predicate</TD ><TD > </TD ></TR ><TR ><TD >F491</TD ><TD >Enhanced integrity management</TD ><TD >Constraint management</TD ><TD > </TD ></TR ><TR ><TD >F501</TD ><TD >Core</TD ><TD >Features and conformance views</TD ><TD > </TD ></TR ><TR ><TD >F501-01</TD ><TD >Core</TD ><TD >SQL_FEATURES view</TD ><TD > </TD ></TR ><TR ><TD >F501-02</TD ><TD >Core</TD ><TD >SQL_SIZING view</TD ><TD > </TD ></TR ><TR ><TD >F501-03</TD ><TD >Core</TD ><TD >SQL_LANGUAGES view</TD ><TD > </TD ></TR ><TR ><TD >F502</TD ><TD > </TD ><TD >Enhanced documentation tables</TD ><TD > </TD ></TR ><TR ><TD >F502-01</TD ><TD > </TD ><TD >SQL_SIZING_PROFILES view</TD ><TD > </TD ></TR ><TR ><TD >F502-02</TD ><TD > </TD ><TD >SQL_IMPLEMENTATION_INFO view</TD ><TD > </TD ></TR ><TR ><TD >F502-03</TD ><TD > </TD ><TD >SQL_PACKAGES view</TD ><TD > </TD ></TR ><TR ><TD >F531</TD ><TD > </TD ><TD >Temporary tables</TD ><TD > </TD ></TR ><TR ><TD >F555</TD ><TD >Enhanced datetime facilities</TD ><TD >Enhanced seconds precision</TD ><TD > </TD ></TR ><TR ><TD >F561</TD ><TD > </TD ><TD >Full value expressions</TD ><TD > </TD ></TR ><TR ><TD >F571</TD ><TD > </TD ><TD >Truth value tests</TD ><TD > </TD ></TR ><TR ><TD >F591</TD ><TD > </TD ><TD >Derived tables</TD ><TD > </TD ></TR ><TR ><TD >F611</TD ><TD > </TD ><TD >Indicator data types</TD ><TD > </TD ></TR ><TR ><TD >F651</TD ><TD > </TD ><TD >Catalog name qualifiers</TD ><TD > </TD ></TR ><TR ><TD >F672</TD ><TD > </TD ><TD >Retrospective check constraints</TD ><TD > </TD ></TR ><TR ><TD >F701</TD ><TD >Enhanced integrity management</TD ><TD >Referential update actions</TD ><TD > </TD ></TR ><TR ><TD >F711</TD ><TD > </TD ><TD >ALTER domain</TD ><TD > </TD ></TR ><TR ><TD >F761</TD ><TD > </TD ><TD >Session management</TD ><TD > </TD ></TR ><TR ><TD >F771</TD ><TD > </TD ><TD >Connection management</TD ><TD > </TD ></TR ><TR ><TD >F781</TD ><TD > </TD ><TD >Self-referencing operations</TD ><TD > </TD ></TR ><TR ><TD >F791</TD ><TD > </TD ><TD >Insensitive cursors</TD ><TD > </TD ></TR ><TR ><TD >F801</TD ><TD > </TD ><TD >Full set function</TD ><TD > </TD ></TR ><TR ><TD >S071</TD ><TD >Enhanced object support</TD ><TD >SQL paths in function and type name resolution</TD ><TD > </TD ></TR ><TR ><TD >S111</TD ><TD >Enhanced object support</TD ><TD >ONLY in query expressions</TD ><TD > </TD ></TR ><TR ><TD >S211</TD ><TD >Enhanced object support</TD ><TD >User-defined cast functions</TD ><TD > </TD ></TR ><TR ><TD >T031</TD ><TD > </TD ><TD >BOOLEAN data type</TD ><TD > </TD ></TR ><TR ><TD >T071</TD ><TD > </TD ><TD >BIGINT data type</TD ><TD > </TD ></TR ><TR ><TD >T141</TD ><TD > </TD ><TD >SIMILAR predicate</TD ><TD > </TD ></TR ><TR ><TD >T151</TD ><TD > </TD ><TD >DISTINCT predicate</TD ><TD > </TD ></TR ><TR ><TD >T171</TD ><TD > </TD ><TD >LIKE clause in table definition</TD ><TD > </TD ></TR ><TR ><TD >T191</TD ><TD >Enhanced integrity management</TD ><TD >Referential action RESTRICT</TD ><TD > </TD ></TR ><TR ><TD >T201</TD ><TD >Enhanced integrity management</TD ><TD >Comparable data types for referential constraints</TD ><TD > </TD ></TR ><TR ><TD >T211-01</TD ><TD >Active database, Enhanced integrity management</TD ><TD >Triggers activated on UPDATE, INSERT, or DELETE of one base table</TD ><TD > </TD ></TR ><TR ><TD >T211-02</TD ><TD >Active database, Enhanced integrity management</TD ><TD >BEFORE triggers</TD ><TD > </TD ></TR ><TR ><TD >T211-03</TD ><TD >Active database, Enhanced integrity management</TD ><TD >AFTER triggers</TD ><TD > </TD ></TR ><TR ><TD >T211-04</TD ><TD >Active database, Enhanced integrity management</TD ><TD >FOR EACH ROW triggers</TD ><TD > </TD ></TR ><TR ><TD >T211-07</TD ><TD >Active database, Enhanced integrity management</TD ><TD >TRIGGER privilege</TD ><TD > </TD ></TR ><TR ><TD >T212</TD ><TD >Enhanced integrity management</TD ><TD >Enhanced trigger capability</TD ><TD > </TD ></TR ><TR ><TD >T231</TD ><TD > </TD ><TD >Sensitive cursors</TD ><TD > </TD ></TR ><TR ><TD >T241</TD ><TD > </TD ><TD >START TRANSACTION statement</TD ><TD > </TD ></TR ><TR ><TD >T271</TD ><TD > </TD ><TD >Savepoints</TD ><TD > </TD ></TR ><TR ><TD >T312</TD ><TD > </TD ><TD >OVERLAY function</TD ><TD > </TD ></TR ><TR ><TD >T321-01</TD ><TD >Core</TD ><TD >User-defined functions with no overloading</TD ><TD > </TD ></TR ><TR ><TD >T321-03</TD ><TD >Core</TD ><TD >Function invocation</TD ><TD > </TD ></TR ><TR ><TD >T321-06</TD ><TD >Core</TD ><TD >ROUTINES view</TD ><TD > </TD ></TR ><TR ><TD >T321-07</TD ><TD >Core</TD ><TD >PARAMETERS view</TD ><TD > </TD ></TR ><TR ><TD >T322</TD ><TD >PSM</TD ><TD >Overloading of SQL-invoked functions and procedures</TD ><TD > </TD ></TR ><TR ><TD >T323</TD ><TD > </TD ><TD >Explicit security for external routines</TD ><TD > </TD ></TR ><TR ><TD >T351</TD ><TD > </TD ><TD >Bracketed SQL comments (/*...*/ comments)</TD ><TD > </TD ></TR ><TR ><TD >T441</TD ><TD > </TD ><TD >ABS and MOD functions</TD ><TD > </TD ></TR ><TR ><TD >T461</TD ><TD > </TD ><TD >Symmetric BETWEEN predicate</TD ><TD > </TD ></TR ><TR ><TD >T501</TD ><TD > </TD ><TD >Enhanced EXISTS predicate</TD ><TD > </TD ></TR ><TR ><TD >T551</TD ><TD > </TD ><TD >Optional key words for default syntax</TD ><TD > </TD ></TR ><TR ><TD >T581</TD ><TD > </TD ><TD >Regular expression substring function</TD ><TD > </TD ></TR ><TR ><TD >T591</TD ><TD > </TD ><TD >UNIQUE constraints of possibly null columns</TD ><TD > </TD ></TR ><TR ><TD >X010</TD ><TD > </TD ><TD >XML type</TD ><TD > </TD ></TR ><TR ><TD >X011</TD ><TD > </TD ><TD >Arrays of XML type</TD ><TD > </TD ></TR ><TR ><TD >X016</TD ><TD > </TD ><TD >Persistent XML values</TD ><TD > </TD ></TR ><TR ><TD >X020</TD ><TD > </TD ><TD >XML concatenation</TD ><TD > </TD ></TR ><TR ><TD >X031</TD ><TD > </TD ><TD >XMLElement</TD ><TD > </TD ></TR ><TR ><TD >X032</TD ><TD > </TD ><TD >XMLForest</TD ><TD > </TD ></TR ><TR ><TD >X033</TD ><TD > </TD ><TD >XMLRoot</TD ><TD > </TD ></TR ><TR ><TD >X034</TD ><TD > </TD ><TD >XMLAgg</TD ><TD > </TD ></TR ><TR ><TD >X036</TD ><TD > </TD ><TD >XMLComment</TD ><TD > </TD ></TR ><TR ><TD >X037</TD ><TD > </TD ><TD >XMLPI</TD ><TD > </TD ></TR ><TR ><TD >X041</TD ><TD > </TD ><TD >Basic table mapping: nulls absent</TD ><TD > </TD ></TR ><TR ><TD >X042</TD ><TD > </TD ><TD >Basic table mapping: null as nil</TD ><TD > </TD ></TR ><TR ><TD >X043</TD ><TD > </TD ><TD >Basic table mapping: table as forest</TD ><TD > </TD ></TR ><TR ><TD >X044</TD ><TD > </TD ><TD >Basic table mapping: table as element</TD ><TD > </TD ></TR ><TR ><TD >X045</TD ><TD > </TD ><TD >Basic table mapping: with target namespace</TD ><TD > </TD ></TR ><TR ><TD >X046</TD ><TD > </TD ><TD >Basic table mapping: data mapping</TD ><TD > </TD ></TR ><TR ><TD >X047</TD ><TD > </TD ><TD >Basic table mapping: metadata mapping</TD ><TD > </TD ></TR ><TR ><TD >X048</TD ><TD > </TD ><TD >Basic table mapping: base64 encoding of binary strings</TD ><TD > </TD ></TR ><TR ><TD >X049</TD ><TD > </TD ><TD >Basic table mapping: hex encoding of binary strings</TD ><TD > </TD ></TR ><TR ><TD >X051</TD ><TD > </TD ><TD >Advanced table mapping: nulls absent</TD ><TD > </TD ></TR ><TR ><TD >X052</TD ><TD > </TD ><TD >Advanced table mapping: null as nil</TD ><TD > </TD ></TR ><TR ><TD >X053</TD ><TD > </TD ><TD >Advanced table mapping: table as forest</TD ><TD > </TD ></TR ><TR ><TD >X054</TD ><TD > </TD ><TD >Advanced table mapping: table as element</TD ><TD > </TD ></TR ><TR ><TD >X055</TD ><TD > </TD ><TD >Advanced table mapping: target namespace</TD ><TD > </TD ></TR ><TR ><TD >X056</TD ><TD > </TD ><TD >Advanced table mapping: data mapping</TD ><TD > </TD ></TR ><TR ><TD >X057</TD ><TD > </TD ><TD >Advanced table mapping: metadata mapping</TD ><TD > </TD ></TR ><TR ><TD >X058</TD ><TD > </TD ><TD >Advanced table mapping: base64 encoding of binary strings</TD ><TD > </TD ></TR ><TR ><TD >X059</TD ><TD > </TD ><TD >Advanced table mapping: hex encoding of binary strings</TD ><TD > </TD ></TR ><TR ><TD >X060</TD ><TD > </TD ><TD >XMLParse: CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X061</TD ><TD > </TD ><TD >XMLParse: DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X062</TD ><TD > </TD ><TD >XMLParse: explicit WHITESPACE option</TD ><TD > </TD ></TR ><TR ><TD >X070</TD ><TD > </TD ><TD >XMLSerialize: CONTENT option</TD ><TD > </TD ></TR ><TR ><TD >X071</TD ><TD > </TD ><TD >XMLSerialize: DOCUMENT option</TD ><TD > </TD ></TR ><TR ><TD >X090</TD ><TD > </TD ><TD >XML document predicate</TD ><TD > </TD ></TR ><TR ><TD >X120</TD ><TD > </TD ><TD >XML parameters in SQL routines</TD ><TD > </TD ></TR ><TR ><TD >X121</TD ><TD > </TD ><TD >XML parameters in external routines</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.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="unsupported-features-sql-standard.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >SQL Conformance</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="features.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Unsupported Features</TD ></TR ></TABLE ></DIV ></BODY ></HTML >
distrib
>
Mandriva
>
2010.0
>
i586
>
media
>
contrib-release
>
by-pkgid
>
415a9558429d583fc9b2617edd1d24a6
>
files
>
204
