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