| 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
| ||
| F121-02 | SET TRANSACTION statement: DIAGNOSTICS SIZE clause
| ||
| 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
| |
| F311-04 | Core | CREATE 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
| ||
| 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
| ||
| 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 | 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 0954612027 | PostgreSQL Reference Manual - Volume 1 - SQL Language Reference | See the print edition |