# D.2. Unsupported Features SQL:2016 中所定義的以下功能並未在此版本的 PostgreSQL 中實作。在某些情況下，有一些等效的功能可以使用。 | Identifier | Core? | Description | Comment | | ---------- | ----- | -------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- | | 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 | | \ | | | 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 | | | B200 | | Polymorphic table functions | | | B201 | | More than one PTF generic table parameter | | | B202 | | PTF Copartitioning | | | B203 | | More than one copartition specification | | | B204 | | PRUNE WHEN EMPTY | | | B205 | | Pass-through columns | | | B206 | | PTF descriptor parameters | | | B207 | | Cross products of partitionings | | | B208 | | PTF component procedure interface | | | B209 | | PTF extended names | | | B211 | | Module language Ada: VARCHAR and NUMERIC support | | | B221 | | Routine language Ada: VARCHAR and NUMERIC support | | | 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 | | | F263 | | Comma-separated predicates in simple CASE expression | | | F291 | | UNIQUE predicate | | | F301 | | CORRESPONDING in query expressions | | | F312 | | MERGE statement | consider INSERT ... ON CONFLICT DO UPDATE | | F313 | | Enhanced MERGE statement | | | F314 | | MERGE statement with DELETE branch | | | F341 | | Usage tables | no ROUTINE\_\*\_USAGE tables | | F403 | | Partitioned joined tables | | | F404 | | Range variable for common column names | | | F451 | | Character set definition | | | F461 | | Named character sets | | | F492 | | Optional table constraint enforcement | | | F521 | | Assertions | | | F671 | | Subqueries in CHECK | intentionally omitted | | F673 | | Reads SQL-data routine invocations in CHECK constraints | | | F693 | | SQL-session and client module collations | | | F695 | | Translation support | | | F696 | | Additional translation documentation | | | F721 | | Deferrable constraints | foreign and unique keys only | | F741 | | Referential MATCH types | no partial match yet | | F812 | Core | Basic 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 | | | R010 | | Row pattern recognition: FROM clause | | | R020 | | Row pattern recognition: WINDOW clause | | | R030 | | Row pattern recognition: full aggregate support | | | S011 | Core | Distinct data types | | | S011-01 | Core | 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 | partially supported | | S081 | | Subtables | | | S091 | | Basic array support | partially supported | | S091-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 | | | S151 | | Type predicate | | | S161 | | Subtype treatment | | | S162 | | Subtype treatment for references | | | 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 | | | 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 | | | 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 | | | T043 | | Multiplier T | | | T044 | | Multiplier P | | | T051 | | Row types | | | T053 | | Explicit aliases for all-fields reference | | | T061 | | UCS support | | | T076 | | DECFLOAT data type | | | T101 | | Enhanced nullability determination | | | T111 | | Updatable joins, unions, and columns | | | T175 | | Generated columns | mostly supported | | T176 | | Sequence generator support | supported except for NEXT VALUE FOR | | T180 | | System-versioned tables | | | T181 | | Application-time period tables | | | T211 | | Basic trigger capability | | | 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 | | | T272 | | Enhanced savepoint management | | | T301 | | Functional dependencies | partially supported | | T321 | Core | Basic SQL-invoked routines | | | T321-05 | Core | RETURN statement | | | T322 | | Declared data type attributes | | | T324 | | Explicit security for SQL routines | | | T326 | | Table functions | | | T332 | | Extended roles | mostly supported | | T434 | | GROUP BY DISTINCT | | | T471 | | Result sets return value | | | T472 | | DESCRIBE CURSOR | | | T495 | | Combined data change and retrieval | different syntax | | T502 | | Period predicates | | | T511 | | Transaction counts | | | T522 | | Default values for IN parameters of SQL-invoked procedures | supported except DEFAULT key word in invocation | | T561 | | Holdable locators | | | T571 | | Array-returning external SQL-invoked functions | | | T572 | | Multiset-returning external SQL-invoked functions | | | T601 | | Local cursor references | | | T616 | | Null treatment option for LEAD and LAG functions | | | T618 | | NTH\_VALUE function | function exists, but some options missing | | T619 | | Nested window functions | | | T625 | | LISTAGG | | | T641 | | Multiple column assignment | only some syntax variants supported | | T652 | | SQL-dynamic statements in SQL routines | | | T654 | | SQL-dynamic statements in external routines | | | T811 | | Basic SQL/JSON constructor functions | | | T812 | | SQL/JSON: JSON\_OBJECTAGG | | | T813 | | SQL/JSON: JSON\_ARRAYAGG with ORDER BY | | | T814 | | Colon in JSON\_OBJECT or JSON\_OBJECTAGG | | | T821 | | Basic SQL/JSON query operators | | | T822 | | SQL/JSON: IS JSON WITH UNIQUE KEYS predicate | | | T823 | | SQL/JSON: PASSING clause | | | T824 | | JSON\_TABLE: specific PLAN clause | | | T825 | | SQL/JSON: ON EMPTY and ON ERROR clauses | | | T826 | | General value expression in ON ERROR or ON EMPTY clauses | | | T827 | | JSON\_TABLE: sibling NESTED COLUMNS clauses | | | T828 | | JSON\_QUERY | | | T829 | | JSON\_QUERY: array wrapper options | | | T830 | | Enforcing unique keys in SQL/JSON constructor functions | | | T838 | | JSON\_TABLE: PLAN DEFAULT clause | | | T839 | | Formatted cast of datetimes to/from character strings | | | M001 | | Datalinks | | | M002 | | Datalinks via SQL/CLI | | | M003 | | Datalinks via Embedded SQL | | | M004 | | Foreign data support | partially supported | | M005 | | Foreign schema support | | | M006 | | GetSQLString routine | | | M007 | | TransmitRequest | | | M009 | | GetOpts and GetStatistics routines | | | M010 | | Foreign data wrapper support | different API | | M011 | | Datalinks via Ada | | | M012 | | Datalinks via C | | | M013 | | Datalinks via COBOL | | | M014 | | Datalinks via Fortran | | | M015 | | Datalinks via M | | | M016 | | Datalinks via Pascal | | | M017 | | Datalinks via PL/I | | | M018 | | Foreign data wrapper interface routines in Ada | | | M019 | | Foreign data wrapper interface routines in C | different API | | M020 | | Foreign data wrapper interface routines in COBOL | | | M021 | | Foreign data wrapper interface routines in Fortran | | | M022 | | Foreign data wrapper interface routines in MUMPS | | | M023 | | Foreign data wrapper interface routines in Pascal | | | M024 | | Foreign data wrapper interface routines in PL/I | | | M030 | | SQL-server foreign data support | | | M031 | | Foreign data wrapper general routines | | | X012 | | Multisets of XML type | | | X013 | | Distinct types of XML type | | | X015 | | Fields of XML type | | | X025 | | XMLCast | | | X030 | | XMLDocument | | | X038 | | XMLText | | | X065 | | XMLParse: BLOB input and CONTENT option | | | X066 | | XMLParse: BLOB input and DOCUMENT option | | | X068 | | XMLSerialize: BOM | | | X069 | | XMLSerialize: INDENT | | | X073 | | XMLSerialize: BLOB serialization and CONTENT option | | | X074 | | XMLSerialize: BLOB serialization and DOCUMENT option | | | X075 | | XMLSerialize: BLOB serialization | | | X076 | | XMLSerialize: VERSION | | | X077 | | XMLSerialize: explicit ENCODING option | | | X078 | | XMLSerialize: explicit XML declaration | | | X080 | | Namespaces in XML publishing | | | X081 | | Query-level XML namespace declarations | | | X082 | | XML namespace declarations in DML | | | X083 | | XML namespace declarations in DDL | | | X084 | | XML namespace declarations in compound statements | | | X085 | | Predefined namespace prefixes | | | X086 | | XML namespace declarations in XMLTable | | | X091 | | XML content predicate | | | X096 | | XMLExists | XPath 1.0 only | | X100 | | Host language support for XML: CONTENT option | | | X101 | | Host language support for XML: DOCUMENT option | | | X110 | | Host language support for XML: VARCHAR mapping | | | X111 | | Host language support for XML: CLOB mapping | | | X112 | | Host language support for XML: BLOB mapping | | | X113 | | Host language support for XML: STRIP WHITESPACE option | | | X114 | | Host language support for XML: PRESERVE WHITESPACE option | | | X131 | | Query-level XMLBINARY clause | | | X132 | | XMLBINARY clause in DML | | | X133 | | XMLBINARY clause in DDL | | | X134 | | XMLBINARY clause in compound statements | | | X135 | | XMLBINARY clause in subqueries | | | X141 | | IS VALID predicate: data-driven case | | | X142 | | IS VALID predicate: ACCORDING TO clause | | | X143 | | IS VALID predicate: ELEMENT clause | | | X144 | | IS VALID predicate: schema location | | | X145 | | IS VALID predicate outside check constraints | | | X151 | | IS VALID predicate with DOCUMENT option | | | X152 | | IS VALID predicate with CONTENT option | | | X153 | | IS VALID predicate with SEQUENCE option | | | X155 | | IS VALID predicate: NAMESPACE without ELEMENT clause | | | X157 | | IS VALID predicate: NO NAMESPACE with ELEMENT clause | | | X160 | | Basic Information Schema for registered XML Schemas | | | X161 | | Advanced Information Schema for registered XML Schemas | | | X170 | | XML null handling options | | | X171 | | NIL ON NO CONTENT option | | | X181 | | XML(DOCUMENT(UNTYPED)) type | | | X182 | | XML(DOCUMENT(ANY)) type | | | X190 | | XML(SEQUENCE) type | | | X191 | | XML(DOCUMENT(XMLSCHEMA)) type | | | X192 | | XML(CONTENT(XMLSCHEMA)) type | | | X200 | | XMLQuery | | | X201 | | XMLQuery: RETURNING CONTENT | | | X202 | | XMLQuery: RETURNING SEQUENCE | | | X203 | | XMLQuery: passing a context item | | | X204 | | XMLQuery: initializing an XQuery variable | | | X205 | | XMLQuery: EMPTY ON EMPTY option | | | X206 | | XMLQuery: NULL ON EMPTY option | | | X211 | | XML 1.1 support | | | X222 | | XML passing mechanism BY REF | parser accepts BY REF but ignores it; passing is always BY VALUE | | X231 | | XML(CONTENT(UNTYPED)) type | | | X232 | | XML(CONTENT(ANY)) type | | | X241 | | RETURNING CONTENT in XML publishing | | | X242 | | RETURNING SEQUENCE in XML publishing | | | X251 | | Persistent XML values of XML(DOCUMENT(UNTYPED)) type | | | X252 | | Persistent XML values of XML(DOCUMENT(ANY)) type | | | X253 | | Persistent XML values of XML(CONTENT(UNTYPED)) type | | | X254 | | Persistent XML values of XML(CONTENT(ANY)) type | | | X255 | | Persistent XML values of XML(SEQUENCE) type | | | X256 | | Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type | | | X257 | | Persistent XML values of XML(CONTENT(XMLSCHEMA)) type | | | X260 | | XML type: ELEMENT clause | | | X261 | | XML type: NAMESPACE without ELEMENT clause | | | X263 | | XML type: NO NAMESPACE with ELEMENT clause | | | X264 | | XML type: schema location | | | X271 | | XMLValidate: data-driven case | | | X272 | | XMLValidate: ACCORDING TO clause | | | X273 | | XMLValidate: ELEMENT clause | | | X274 | | XMLValidate: schema location | | | X281 | | XMLValidate with DOCUMENT option | | | X282 | | XMLValidate with CONTENT option | | | X283 | | XMLValidate with SEQUENCE option | | | X284 | | XMLValidate: NAMESPACE without ELEMENT clause | | | X286 | | XMLValidate: NO NAMESPACE with ELEMENT clause | | | X300 | | XMLTable | XPath 1.0 only | | X305 | | XMLTable: initializing an XQuery variable | |