| The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group Paperback (6"x9"), 454 pages ISBN 9781906966041 RRP £14.95 ($19.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
12.11 Unsupported Features
The following features defined in SQL:2008 are not implemented in this release of PostgreSQL. In a few cases, equivalent functionality is available.
| Identifier | Description [Package]
|
| 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 | <describe input statement>
|
| 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
|
| E081 | Basic Privileges [Core]
|
| E081-09 | USAGE privilege [Core]
|
| E153 | Updatable queries with subqueries [Core]
|
| E182 | Module language [Core]
|
| 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 | Multiple module support [Core]
|
| F202 | TRUNCATE TABLE: identity column restart option
|
| F262 | Extended CASE expression
|
| F263 | Comma-separated predicates in simple CASE expression
|
| F291 | UNIQUE predicate
|
| F301 | CORRESPONDING in query expressions
|
| F311 | Schema definition statement [Core]
|
| F311-04 | CREATE VIEW: WITH CHECK OPTION [Core]
|
| F312 | MERGE statement
|
| F313 | Enhanced MERGE statement
|
| F341 | Usage tables
|
| F394 | Optional normal form specification
|
| F403 | Partitioned joined tables
|
| F451 | Character set definition
|
| F461 | Named character sets
|
| F521 | Assertions [Enhanced integrity management]
|
| F641 | Row and table constructors
|
| F671 | Subqueries in CHECK (11) [Enhanced integrity management]
|
| F690 | Collation support
|
| F692 | Enhanced collation support
|
| F693 | SQL-session and client module collations
|
| F695 | Translation support
|
| F696 | Additional translation documentation
|
| F721 | Deferrable constraints (12)
|
| F741 | Referential MATCH types (13)
|
| F751 | View CHECK enhancements
|
| F812 | Basic flagging [Core]
|
| 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
|
| S011 | Distinct data types [Core]
|
| S011-01 | USER_DEFINED_TYPES view [Core]
|
| S023 | Basic structured types [Basic object support]
|
| S024 | Enhanced structured types [Enhanced object support]
|
| S025 | Final structured types
|
| S026 | Self-referencing structured types
|
| S027 | Create method by specific method name
|
| S028 | Permutable UDT options list
|
| S041 | Basic reference types [Basic object support]
|
| S043 | Enhanced reference types [Enhanced object support]
|
| S051 | Create table of type [Basic object support]
|
| S081 | Subtables [Enhanced object support]
|
| S091 | Basic array support (14)
|
| 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 | Type predicate [Basic object support]
|
| S161 | Subtype treatment [Enhanced object support]
|
| S162 | Subtype treatment for references
|
| S202 | SQL-invoked routines on multisets
|
| S231 | Structured type locators [Enhanced object support]
|
| 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 LOB data type support [Basic object support]
|
| T041-01 | BLOB data type [Basic object support]
|
| T041-02 | CLOB data type [Basic object support]
|
| T041-03 | POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types [Basic object support]
|
| T041-04 | Concatenation of LOB data types [Basic object support]
|
| T041-05 | LOB locator: non-holdable [Basic object support]
|
| 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 determiniation
|
| 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
|
| T211 | Basic trigger capability [Active database, Enhanced integrity management]
|
| T211-06 | Support for run-time rules for the interaction of triggers and constraints [Active database, Enhanced integrity management]
|
| T211-08 | Multiple triggers for the same event are executed in the order in which they were created in the catalog (15) [Active database, Enhanced integrity management]
|
| T213 | INSTEAD OF triggers
|
| T251 | SET TRANSACTION statement: LOCAL option
|
| T261 | Chained transactions
|
| T272 | Enhanced savepoint management
|
| T285 | Enhanced derived column names
|
| T301 | Functional dependencies
|
| T321 | Basic SQL-invoked routines [Core]
|
| T321-02 | User-defined stored procedures with no overloading [Core]
|
| T321-04 | CALL statement [Core]
|
| T321-05 | RETURN statement [Core]
|
| T324 | Explicit security for SQL routines
|
| T325 | Qualified SQL parameter references
|
| T326 | Table functions
|
| T331 | Basic roles
|
| T332 | Extended roles
|
| T431 | Extended grouping capabilities [OLAP]
|
| T432 | Nested and concatenated GROUPING SETS
|
| T433 | Multiargument GROUPING function
|
| T434 | GROUP BY DISTINCT
|
| T471 | Result sets return value
|
| T491 | LATERAL derived table
|
| T511 | Transaction counts
|
| 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 | Elementary OLAP operations (16) [OLAP]
|
| T612 | Advanced OLAP operations (17)
|
| T613 | Sampling
|
| T616 | Null treatment option for LEAD and LAG functions
|
| T618 | NTH_VALUE function (18)
|
| T641 | Multiple column assignment (19)
|
| 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
|
| 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
|
| X400 | Name and identifier mapping |
| ISBN 9781906966041 | The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference | See the print edition |