D.2. 未支持特性

D.2. 未支持特性上一页 上一级附录 D. SQL 符合性起始页 下一页D.2. 未支持特性 下列定义在SQL:2011中的特性还没有在这个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 B035 Non-extended descriptor names 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 B211 Module language Ada: VARCHAR and NUMERIC support B221 Routine language Ada: VARCHAR and NUMERIC support E182CoreModule language F054 TIMESTAMP in DATE type precedence list F121 Basic diagnostics management F121-01 GET DIAGNOSTICS statement F121-02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause F122 Enhanced diagnostics management F123 All diagnostics F181CoreMultiple module support F263 Comma-separated predicates in simple CASE expression F291 UNIQUE predicate F301 CORRESPONDING in query expressions F311CoreSchema definition statement F312 MERGE statementconsider INSERT ... ON CONFLICT DO UPDATEF313 Enhanced MERGE statement F314 MERGE statement with DELETE branch F341 Usage tablesno ROUTINE_*_USAGE tablesF385 Drop column generation expression clause F394 Optional normal form specification F403 Partitioned joined tables F451 Character set definition F461 Named character sets F492 Optional table constraint enforcement F521Enhanced integrity managementAssertions F671Enhanced integrity managementSubqueries in CHECKintentionally omittedF693 SQL-session and client module collations F695 Translation support F696 Additional translation documentation F721 Deferrable constraintsforeign and unique keys onlyF741 Referential MATCH typesno partial match yetF812CoreBasic flagging F813 Extended flagging F821 Local table references F831 Full cursor update F831-01 Updatable scrollable cursors F831-02 Updatable ordered cursors F841 LIKE_REGEX predicate F842 OCCURRENCES_REGEX function F843 POSITION_REGEX function F844 SUBSTRING_REGEX function F845 TRANSLATE_REGEX function F846 Octet support in regular expression operators F847 Nonconstant regular expressions F866 FETCH FIRST clause: PERCENT option F867 FETCH FIRST clause: WITH TIES option S011CoreDistinct data types S011-01CoreUSER_DEFINED_TYPES view S023Basic object supportBasic structured types S024Enhanced object supportEnhanced structured types S025 Final structured types S026 Self-referencing structured types S027 Create method by specific method name S028 Permutable UDT options list S041Basic object supportBasic reference types S043Enhanced object supportEnhanced reference types S051Basic object supportCreate table of typepartially supportedS081Enhanced object supportSubtables S091 Basic array supportpartially supportedS091-01 Arrays of built-in data types S091-02 Arrays of distinct types S091-03 Array expressions S094 Arrays of reference types S097 Array element assignment S151Basic object supportType predicate S161Enhanced object supportSubtype treatment S162 Subtype treatment for references S202 SQL-invoked routines on multisets S231Enhanced object supportStructured 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 S401 Distinct types based on array types S402 Distinct types based on distinct types S403 ARRAY_MAX_CARDINALITY S404 TRIM_ARRAY T011 Timestamp in Information Schema T021 BINARY and VARBINARY data types T022 Advanced support for BINARY and VARBINARY data types T023 Compound binary literal T024 Spaces in binary literals T041Basic object supportBasic LOB data type support T041-01Basic object supportBLOB data type T041-02Basic object supportCLOB data type T041-03Basic object supportPOSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types T041-04Basic object supportConcatenation of LOB data types T041-05Basic object supportLOB locator: non-holdable T042 Extended LOB data type support T043 Multiplier T T044 Multiplier P T051 Row types T052 MAX and MIN for row types T053 Explicit aliases for all-fields reference T061 UCS support T101 Enhanced nullability determination T111 Updatable joins, unions, and columns T175 Generated columns T176 Sequence generator support T180 System-versioned tables T181 Application-time period tables T211Active database, Enhanced integrity managementBasic trigger capability T211-06Active database, Enhanced integrity managementSupport for run-time rules for the interaction of triggers and constraints T211-08Active database, Enhanced integrity managementMultiple triggers for the same event are executed in the order in which they were created in the catalogintentionally omittedT251 SET TRANSACTION statement: LOCAL option T261 Chained transactions T272 Enhanced savepoint management T301 Functional dependenciespartially supportedT321CoreBasic SQL-invoked routines T321-02CoreUser-defined stored procedures with no overloading T321-04CoreCALL statement T321-05CoreRETURN statement T322PSMDeclared data type attributes T324 Explicit security for SQL routines T326 Table functions T332 Extended rolesmostly supportedT434 GROUP BY DISTINCT T471 Result sets return value T472 DESCRIBE CURSOR T495 Combined data change and retrievaldifferent syntaxT502 Period predicates T511 Transac