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
<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
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
Last modified 2mo ago
Export as PDF
Copy link
Edit on GitHub