以下の SQL99 で定義されている機能は本リリースの PostgreSQL では実装されていません。 たまに同等の機能が実装されていることがあります。
| 識別子 | パッケージ | 説明 | コメント |
|---|---|---|---|
| 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 |