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

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

PreviousD.1. Supported Features NextD.3. XML Limits and Conformance to SQL/XML