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 |