Historical version. PostgreSQL 7.4 has reached end of support. See the current manual.
D.2. Unsupported Features
The following features defined in SQL99 are not implemented in this release of PostgreSQL. In a few cases, equivalent functionality is available.
| Identifier | Package | Description | Comment |
|---|---|---|---|
| B011 | Core | Embedded Ada | |
| B013 | Core | Embedded COBOL | |
| B014 | Core | Embedded Fortran | |
| B015 | Core | Embedded MUMPS | |
| B016 | Core | Embedded Pascal | |
| B017 | Core | Embedded PL/I | |
| B031 | Basic dynamic SQL | ||
| B032 | Extended dynamic SQL | ||
| B032-01 | <describe input> statement | ||
| B041 | Extensions to embedded SQL exception declarations | ||
| B051 | Enhanced execution rights | ||
| E081 | Core | Basic Privileges | |
| E081-05 | Core | UPDATE privilege at the column level | |
| E081-07 | Core | REFERENCES privilege at the column level | |
| 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 | |
| F111 | Isolation levels other than SERIALIZABLE | ||
| F111-01 | READ UNCOMMITTED isolation level | ||
| F111-03 | REPEATABLE READ isolation level | ||
| F121 | Basic diagnostics management | ||
| F121-01 | GET DIAGNOSTICS statement | ||
| F121-02 | SET TRANSACTION statement: DIAGNOSTICS SIZE clause | ||
| F181 | Multiple module support | ||
| F291 | UNIQUE predicate | ||
| F301 | CORRESPONDING in query expressions | ||
| F311 | Core | Schema definition statement | |
| F311-04 | Core | CREATE VIEW: WITH CHECK OPTION | |
| F341 | Usage tables | ||
| F451 | Character set definition | ||
| F461 | Named character sets | ||
| F521 | Enhanced integrity management | Assertions | |
| F641 | OLAP facilities | Row and table constructors | |
| F661 | Simple tables | ||
| F671 | Enhanced integrity management | Subqueries in CHECK | intentionally omitted |
| F691 | Collation and translation | ||
| 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 for "Core SQL Flagging" and "Catalog Lookup" only | ||
| 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, SQL/MM support | Basic structured types | |
| S024 | Enhanced object support, SQL/MM support | Enhanced structured types | |
| 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 | SQL/MM support | Basic array support | |
| S091-01 | SQL/MM support | Arrays of built-in data types | |
| S091-02 | SQL/MM support | Arrays of distinct types | |
| S091-03 | SQL/MM support | Array expressions | |
| S092 | SQL/MM support | Arrays of user-defined types | |
| S094 | Arrays of reference types | ||
| S151 | Basic object support | Type predicate | |
| S161 | Enhanced object support | Subtype treatment | |
| S201 | SQL routines on arrays | ||
| S201-01 | Array parameters | ||
| S201-02 | Array as result type of functions | ||
| S231 | Enhanced object support | Structured type locators | |
| S232 | Array locators | ||
| S241 | Enhanced object support | Transform functions | |
| S251 | User-defined orderings | ||
| S261 | Specific type method | ||
| 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 | ||
| T111 | Updatable joins, unions, and columns | ||
| T121 | WITH (excluding RECURSIVE) in query expression | ||
| T131 | Recursive query | ||
| T211 | Enhanced integrity management, Active database | Basic trigger capability | |
| T211-05 | Enhanced integrity management, Active database | Ability to specify a search condition that must be true before the trigger is invoked | |
| T211-06 | Enhanced integrity management, Active database | Support for run-time rules for the interaction of triggers and constraints | |
| T211-08 | Enhanced integrity management, Active database | Multiple triggers for the same event are executed in the order in which they were created | intentionally omitted |
| T251 | SET TRANSACTION statement: LOCAL option | ||
| T261 | Chained transactions | ||
| T271 | Savepoints | ||
| 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 | |
| T331 | Basic roles | ||
| T332 | Extended roles | ||
| T401 | INSERT into a cursor | ||
| T411 | UPDATE statement: SET ROW option | ||
| T431 | OLAP facilities | CUBE and ROLLUP operations | |
| T461 | Symmetric BETWEEN predicate | ||
| 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 | ||
| T601 | Local cursor references |
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.