- publishing free software manuals
PostgreSQL Reference Manual - Volume 1 - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 716 pages
ISBN 0954612027
RRP £32.00 ($49.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

14.13 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.

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 <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
C011 Core Call-Level Interface
E081 Core Basic Privileges
E081-05 Core UPDATE privilege at the column level
E081-07 Core REFERENCES privilege at the column level
E081-09 Core USAGE privilege
E121 Core Basic cursor support
E121-06 Core Positioned UPDATE statement
E121-07 Core Positioned DELETE statement
E153 Core Updatable queries with subqueries
E182 Core Module language
F121 Basic diagnostics management
F121-01 GET DIAGNOSTICS statement
F181 Core Multiple module support
F262 Extended CASE expression
F263 Comma-separated predicates in simple CASE expression
F291 UNIQUE predicate
F301 CORRESPONDING in query expressions
F311 Core Schema definition statement
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
F521 Enhanced integrity management Assertions
F641 Row and table constructors
F661 Simple tables
F671 Enhanced integrity management Subqueries in CHECK intentionally 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 constraints foreign keys only
F731 INSERT column privileges
F741 Referential MATCH types no partial match yet
F751 View CHECK enhancements
F811 Extended flagging
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
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
S081 Enhanced object support Subtables
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
S151 Basic object support Type predicate
S161 Enhanced object support Subtype 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
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
T011 Timestamp in Information Schema
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
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
T211 Active database, Enhanced integrity management Basic trigger capability
T211-05 Active database, Enhanced integrity management Ability to specify a search condition that must be true before the trigger is invoked
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
T281 SELECT privilege with column granularity
T301 Functional dependencies
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
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
T431 OLAP Extended grouping capabilities
T432 Nested and concatenated GROUPING SETS
T433 Multiargument GROUPING function
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 OLAP Elementary OLAP operations
T612 Advanced OLAP operations
T613 Sampling
T621 Enhanced numeric functions
T631 Core IN 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
ISBN 0954612027PostgreSQL Reference Manual - Volume 1 - SQL Language ReferenceSee the print edition