婋麵認底婘 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 |