D.2. Unsupported Features

The following features defined in SQL:2003 are not implemented in this release of PostgreSQL. In a few cases, equivalent functionality is available.

IdentifierPackageDescriptionComment
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 
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 
C011CoreCall-Level Interface 
E081CoreBasic Privileges 
E081-05CoreUPDATE privilege at the column level 
E081-07CoreREFERENCES privilege at the column level 
E081-09CoreUSAGE privilege 
E121CoreBasic cursor support 
E121-06CorePositioned UPDATE statement 
E121-07CorePositioned DELETE statement 
E153CoreUpdatable queries with subqueries 
E182CoreModule language 
F121 Basic diagnostics management 
F121-01 GET DIAGNOSTICS statement 
F121-02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause 
F181CoreMultiple module support 
F262 Extended CASE expression 
F263 Comma-separated predicates in simple CASE expression 
F291 UNIQUE predicate 
F301 CORRESPONDING in query expressions 
F311CoreSchema definition statement 
F311-04CoreCREATE VIEW: WITH CHECK OPTION 
F312 MERGE statement 
F341 Usage tables 
F392 Unicode escapes in identifiers 
F393 Unicode escapes in literals 
F402 Named column joins for LOBs, arrays, and multisets 
F442 Mixed column references in set functions 
F451 Character set definition 
F461 Named character sets 
F521Enhanced integrity managementAssertions 
F641 Row and table constructors 
F661 Simple tables 
F671Enhanced integrity managementSubqueries in CHECKintentionally omitted
F691 Collation and translation 
F692 Enhanced collation support 
F693 SQL-session and client module collations 
F695 Translation support 
F696 Additional translation documentation 
F721 Deferrable constraintsforeign keys only
F731 INSERT column privileges 
F741 Referential MATCH typesno partial match yet
F751 View CHECK enhancements 
F811 Extended flagging 
F812CoreBasic flagging 
F813 Extended flagging 
F821 Local table references 
F831 Full cursor update 
F831-01 Updatable scrollable cursors 
F831-02 Updatable ordered cursors 
S011CoreDistinct data types 
S011-01CoreUSER_DEFINED_TYPES view 
S023Basic object supportBasic structured types 
S024Enhanced object supportEnhanced structured types 
S025 Final structured types 
S026 Self-referencing structured types 
S027 Create method by specific method name 
S028 Permutable UDT options list 
S041Basic object supportBasic reference types 
S043Enhanced object supportEnhanced reference types 
S051Basic object supportCreate table of type 
S081Enhanced object supportSubtables 
S091 Basic array support 
S091-01 Arrays of built-in data types 
S091-02 Arrays of distinct types 
S091-03 Array expressions 
S092 Arrays of user-defined types 
S094 Arrays of reference types 
S095 Array constructors by query 
S096 Optional array bounds 
S097 Array element assignment 
S151Basic object supportType predicate 
S161Enhanced object supportSubtype treatment 
S162 Subtype treatment for references 
S201 SQL-invoked routines on arrays 
S201-01 Array parameters 
S201-02 Array as result type of functions 
S202 SQL-invoked routines on multisets 
S231Enhanced object supportStructured 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 
T011 Timestamp in Information Schema 
T041Basic object supportBasic LOB data type support 
T041-01Basic object supportBLOB data type 
T041-02Basic object supportCLOB data type 
T041-03Basic object supportPOSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types 
T041-04Basic object supportConcatenation of LOB data types 
T041-05Basic object supportLOB locator: non-holdable 
T042 Extended LOB data type support 
T051 Row types 
T052 MAX and MIN for row types 
T053 Explicit aliases for all-fields reference 
T061 UCS support 
T111 Updatable joins, unions, and columns 
T121 WITH (excluding RECURSIVE) in query expression 
T122 WITH (excluding RECURSIVE) in subquery 
T131 Recursive query 
T132 Recursive query in subquery 
T152 DISTINCT predicate with negation 
T172 AS subquery clause in table definition 
T173 Extended LIKE clause in table definition 
T174 Identity columns 
T175 Generated columns 
T176 Sequence generator support 
T211Active database, Enhanced integrity managementBasic trigger capability 
T211-05Active database, Enhanced integrity managementAbility to specify a search condition that must be true before the trigger is invoked 
T211-06Active database, Enhanced integrity managementSupport for run-time rules for the interaction of triggers and constraints 
T211-08Active database, Enhanced integrity managementMultiple triggers for the same event are executed in the order in which they were created in the catalogintentionally omitted
T251 SET TRANSACTION statement: LOCAL option 
T261 Chained transactions 
T272 Enhanced savepoint management 
T281 SELECT privilege with column granularity 
T301 Functional dependencies 
T321CoreBasic SQL-invoked routines 
T321-02CoreUser-defined stored procedures with no overloading 
T321-04CoreCALL statement 
T321-05CoreRETURN statement 
T324 Explicit security for SQL routines 
T325 Qualified SQL parameter references 
T326 Table functions 
T331 Basic roles 
T332 Extended roles 
T401 INSERT into a cursor 
T411 UPDATE statement: SET ROW option 
T431OLAPExtended grouping capabilities 
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 
T611OLAPElementary OLAP operations 
T612 Advanced OLAP operations 
T613 Sampling 
T621 Enhanced numeric functions 
T631CoreIN predicate with one list element 
T641 Multiple column assignment 
T651 SQL-schema statements in SQL routines 
T652 SQL-dynamic statements in SQL routines 
T653 SQL-schema statements in external routines 
T654 SQL-dynamic statements in external routines 
T655 Cyclically dependent routines 
X012 Multisets of XML type 
X013 Distinct types of XML type 
X014 Attributes of XML type 
X015 Fields of XML type 
X035 XMLAgg: ORDER BY option 
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 
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 
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