Historical version. PostgreSQL 7.3 has reached end of support. See the current manual.
C.2. Unsupported Features
The following features defined in SQL99 are not implemented in the current 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-1 | <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 | |
| E081-08 | Core | WITH GRANT OPTION | |
| E121 | Core | Basic cursor support | |
| E121-04 | Core | OPEN statement | (cursor) |
| E121-06 | Core | Positioned UPDATE statement | (cursor) |
| E121-07 | Core | Positioned DELETE statement | (cursor) |
| E121-17 | Core | WITH HOLD cursors | Cursor to stay open across transactions |
| E152 | Core | Basic SET TRANSACTION statement | |
| E152-02 | Core | SET TRANSACTION statement: READ ONLY and READ WRITE clauses | Syntax accepted; READ ONLY not supported |
| E153 | Core | Updatable queries with subqueries | |
| E171 | Core | SQLSTATE support | |
| F181 | Multiple module support | ||
| E182 | Core | Module language | |
| F021 | Core | Basic information schema | |
| F021-01 | Core | COLUMNS view | |
| F021-02 | Core | TABLES view | |
| F021-03 | Core | VIEWS view | |
| F021-04 | Core | TABLE_CONSTRAINTS view | |
| F021-05 | Core | REFERENTIAL_CONSTRAINTS view | |
| F021-06 | Core | CHECK_CONSTRAINTS view | |
| F031-19 | Core | REVOKE statement: RESTRICT clause | |
| F034 | Extended REVOKE statement | ||
| F034-01 | REVOKE statement performed by other than the owner of a schema object | ||
| F034-02 | REVOKE statement: GRANT OPTION FOR clause | ||
| F034-03 | REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION | ||
| 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 | ||
| F231 | Privilege Tables | ||
| F231-01 | TABLE_PRIVILEGES view | ||
| F231-02 | COLUMN_PRIVILEGES view | ||
| F231-03 | USAGE_PRIVILEGES view | ||
| F291 | UNIQUE predicate | ||
| F301 | CORRESPONDING in query expressions | ||
| F311-04 | Core | CREATE VIEW: WITH CHECK OPTION | |
| F341 | Usage tables | ||
| F431 | Read-only scrollable cursors | ||
| F431-02 | FETCH FIRST | ||
| F431-03 | FETCH LAST | ||
| F431-05 | FETCH ABSOLUTE | ||
| F451 | Character set definition | ||
| F461 | Named character sets | ||
| F501 | Core | Features and conformance views | |
| F501-01 | Core | SQL_FEATURES view | |
| F501-02 | Core | SQL_SIZING view | |
| F501-03 | Core | SQL_LANGUAGES view | |
| F502 | Enhanced documentation tables | ||
| F502-01 | SQL_SIZING_PROFILES view | ||
| F502-02 | SQL_IMPLEMENTATION_INFO view | ||
| F502-03 | SQL_PACKAGES view | ||
| 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 | ||
| F711 | ALTER domain | ||
| F721 | Deferrable constraints | foreign keys only | |
| F731 | INSERT column privileges | ||
| F741 | Referential MATCH types | no partial match yet | |
| F751 | View CHECK enhancements | ||
| F771 | Connection management | ||
| F781 | Self-referencing operations | ||
| 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, SQL/MM support | Enhanced object 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 | PostgreSQL arrays are different |
| 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 | IS OF |
| S161 | Enhanced object support | Subtype treatment | TREAT(expr AS type) |
| 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 | CREATE ORDERING FOR | |
| 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 | ||
| T171 | LIKE clause in table definition | CREATE TABLE T1 (LIKE T2) | |
| T211 | Enhanced integrity management, Active database | Basic trigger capability | |
| T211-05 | Enhanced integrity management | Ability to specify a search condition that must be true before the trigger is invoked | |
| T211-06 | Enhanced integrity management | Support for run-time rules for the interaction of triggers and constraints | |
| T211-08 | Enhanced integrity management | Multiple triggers for the same the event are executed in the order in which they were created | |
| T212 | Enhanced integrity management | Enhanced trigger capability | |
| 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 | |
| T321-06 | Core | ROUTINES view | |
| T321-07 | Core | PARAMETERS view | |
| 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.