下面这些在 SQL:2003 中定义的特定在目前的 PostgreSQL 版本中还没有实现,不过在某些情况下可以获得等效的功能。
标识符 | 包 | 描述 | 注释 |
---|---|---|---|
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 | 核心 | Call-Level Interface | |
E081 | 核心 | Basic Privileges | |
E081-05 | 核心 | UPDATE privilege at the column level | |
E081-07 | 核心 | REFERENCES privilege at the column level | |
E081-09 | 核心 | USAGE privilege | |
E121 | 核心 | Basic cursor support | |
E121-06 | 核心 | Positioned UPDATE statement | |
E121-07 | 核心 | Positioned DELETE statement | |
E153 | 核心 | Updatable queries with subqueries | |
E182 | 核心 | Module language | |
F121 | Basic diagnostics management | ||
F121-01 | GET DIAGNOSTICS statement | ||
F121-02 | SET TRANSACTION statement: DIAGNOSTICS SIZE clause | ||
F181 | 核心 | Multiple module support | |
F262 | Extended CASE expression | ||
F263 | Comma-separated predicates in simple CASE expression | ||
F291 | UNIQUE predicate | ||
F301 | CORRESPONDING in query expressions | ||
F311 | 核心 | Schema definition statement | |
F311-04 | 核心 | 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 | 增强完整性管理 | Assertions | |
F641 | Row and table constructors | ||
F661 | Simple tables | ||
F671 | 增强完整性管理 | 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 | 核心 | Basic flagging | |
F813 | Extended flagging | ||
F821 | Local table references | ||
F831 | Full cursor update | ||
F831-01 | Updatable scrollable cursors | ||
F831-02 | Updatable ordered cursors | ||
S011 | 核心 | Distinct data types | |
S011-01 | 核心 | USER_DEFINED_TYPES view | |
S023 | 基本的对象支持 | Basic structured types | |
S024 | 增强的对象支持 | 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 reference types | |
S043 | 增强的对象支持 | Enhanced reference types | |
S051 | 基本的对象支持 | Create table of type | |
S081 | 增强的对象支持 | 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 | 基本的对象支持 | Type predicate | |
S161 | 增强的对象支持 | 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 | 增强的对象支持 | 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 LOB data type support | |
T041-01 | 基本的对象支持 | BLOB data type | |
T041-02 | 基本的对象支持 | CLOB data type | |
T041-03 | 基本的对象支持 | POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types | |
T041-04 | 基本的对象支持 | Concatenation of LOB data types | |
T041-05 | 基本的对象支持 | 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 | 激活数据库,增强完整性管理 | Basic trigger capability | |
T211-05 | 激活数据库,增强完整性管理 | Ability to specify a search condition that must be true before the trigger is invoked | |
T211-06 | 激活数据库,增强完整性管理 | Support for run-time rules for the interaction of triggers and constraints | |
T211-08 | 激活数据库,增强完整性管理 | 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 | 核心 | Basic SQL-invoked routines | |
T321-02 | 核心 | User-defined stored procedures with no overloading | |
T321-04 | 核心 | CALL statement | |
T321-05 | 核心 | 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 | 核心 | 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 |