Documentation PostgreSQL 12.22 » Annexes » Conformité SQL » Fonctionnalités non supportées
Précédent Niveau supérieur Suivant
D.1. Fonctionnalités supportées Sommaire D.3. Limitations XML et conformité à SQL/XML

D.2. Fonctionnalités non supportées

Les fonctionnalités suivantes définies dans SQL:2011 ne sont pas implantées dans cette version de PostgreSQL. Dans certains cas, des fonctionnalités similaires sont disponibles.

IdentifiantPaquetageDescriptionCommentaire
B011Embedded Ada
B013Embedded COBOL
B014Embedded Fortran
B015Embedded MUMPS
B016Embedded Pascal
B017Embedded PL/I
B031Basic dynamic SQL
B032Extended dynamic SQL
B032-01<describe input statement>
B033Untyped SQL-invoked function arguments
B034Dynamic specification of cursor attributes
B035Non-extended descriptor names
B041Extensions to embedded SQL exception declarations
B051Enhanced execution rights
B111Module language Ada
B112Module language C
B113Module language COBOL
B114Module language Fortran
B115Module language MUMPS
B116Module language Pascal
B117Module language PL/I
B121Routine language Ada
B122Routine language C
B123Routine language COBOL
B124Routine language Fortran
B125Routine language MUMPS
B126Routine language Pascal
B127Routine language PL/I
B128Routine language SQL
B200Polymorphic table functions
B201More than one PTF generic table parameter
B202PTF Copartitioning
B203More than one copartition specification
B204PRUNE WHEN EMPTY
B205Pass-through columns
B206PTF descriptor parameters
B207Cross products of partitionings
B208PTF component procedure interface
B209PTF extended names
B211Module language Ada: VARCHAR and NUMERIC support
B221Routine language Ada: VARCHAR and NUMERIC support
E182CoreModule language
F054TIMESTAMP in DATE type precedence list
F121Basic diagnostics management
F121-01GET DIAGNOSTICS statement
F121-02SET TRANSACTION statement: DIAGNOSTICS SIZE clause
F122Enhanced diagnostics management
F123All diagnostics
F181CoreMultiple module support
F263Comma-separated predicates in simple CASE expression
F291UNIQUE predicate
F301CORRESPONDING in query expressions
F311CoreSchema definition statement
F312MERGE statementconsider INSERT ... ON CONFLICT DO UPDATE
F313Enhanced MERGE statement
F314MERGE statement with DELETE branch
F341Usage tablesno ROUTINE_*_USAGE tables
F385Drop column generation expression clause
F394Optional normal form specification
F403Partitioned joined tables
F404Range variable for common column names
F451Character set definition
F461Named character sets
F492Optional table constraint enforcement
F521Enhanced integrity managementAssertions
F671Enhanced integrity managementSubqueries in CHECKintentionally omitted
F673Reads SQL-data routine invocations in CHECK constraints
F693SQL-session and client module collations
F695Translation support
F696Additional translation documentation
F721Deferrable constraintsforeign and unique keys only
F741Referential MATCH typesno partial match yet
F812CoreBasic flagging
F813Extended flagging
F821Local table references
F831Full cursor update
F831-01Updatable scrollable cursors
F831-02Updatable ordered cursors
F841LIKE_REGEX predicate
F842OCCURRENCES_REGEX function
F843POSITION_REGEX function
F844SUBSTRING_REGEX function
F845TRANSLATE_REGEX function
F846Octet support in regular expression operators
F847Nonconstant regular expressions
F866FETCH FIRST clause: PERCENT option
F867FETCH FIRST clause: WITH TIES option
R010Row pattern recognition: FROM clause
R020Row pattern recognition: WINDOW clause
R030Row pattern recognition: full aggregate support
S011CoreDistinct data types
S011-01CoreUSER_DEFINED_TYPES view
S023Basic object supportBasic structured types
S024Enhanced object supportEnhanced structured types
S025Final structured types
S026Self-referencing structured types
S027Create method by specific method name
S028Permutable UDT options list
S041Basic object supportBasic reference types
S043Enhanced object supportEnhanced reference types
S051Basic object supportCreate table of typepartially supported
S081Enhanced object supportSubtables
S091Basic array supportpartially supported
S091-01Arrays of built-in data types
S091-02Arrays of distinct types
S091-03Array expressions
S094Arrays of reference types
S097Array element assignment
S151Basic object supportType predicate
S161Enhanced object supportSubtype treatment
S162Subtype treatment for references
S202SQL-invoked routines on multisets
S231Enhanced object supportStructured type locators
S232Array locators
S233Multiset locators
S241Transform functions
S242Alter transform statement
S251User-defined orderings
S261Specific type method
S271Basic multiset support
S272Multisets of user-defined types
S274Multisets of reference types
S275Advanced multiset support
S281Nested collection types
S291Unique constraint on entire row
S401Distinct types based on array types
S402Distinct types based on distinct types
S403ARRAY_MAX_CARDINALITY
S404TRIM_ARRAY
T011Timestamp in Information Schema
T021BINARY and VARBINARY data types
T022Advanced support for BINARY and VARBINARY data types
T023Compound binary literal
T024Spaces 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
T042Extended LOB data type support
T043Multiplier T
T044Multiplier P
T051Row types
T053Explicit aliases for all-fields reference
T061UCS support
T076DECFLOAT data type
T101Enhanced nullability determination
T111Updatable joins, unions, and columns
T175Generated columns
T176Sequence generator support
T180System-versioned tables
T181Application-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 omitted
T251SET TRANSACTION statement: LOCAL option
T272Enhanced savepoint management
T301Functional dependenciespartially supported
T321CoreBasic SQL-invoked routines
T321-05CoreRETURN statement
T322PSMDeclared data type attributes
T324Explicit security for SQL routines
T326Table functions
T332Extended rolesmostly supported
T434GROUP BY DISTINCT
T471Result sets return value
T472DESCRIBE CURSOR
T495Combined data change and retrievaldifferent syntax
T502Period predicates
T511Transaction counts
T522Default values for IN parameters of SQL-invoked proceduressupported except DEFAULT key word in invocation
T561Holdable locators
T571Array-returning external SQL-invoked functions
T572Multiset-returning external SQL-invoked functions
T601Local cursor references
T612Advanced OLAP operationssome forms supported
T616Null treatment option for LEAD and LAG functions
T618NTH_VALUE functionfunction exists, but some options missing
T619Nested window functions
T625LISTAGG
T641Multiple column assignmentonly some syntax variants supported
T652SQL-dynamic statements in SQL routines
T653SQL-schema statements in external routines
T654SQL-dynamic statements in external routines
T811Basic SQL/JSON constructor functions
T812SQL/JSON: JSON_OBJECTAGG
T813SQL/JSON: JSON_ARRAYAGG with ORDER BY
T814Colon in JSON_OBJECT or JSON_OBJECTAGG
T821Basic SQL/JSON query operators
T822SQL/JSON: IS JSON WITH UNIQUE KEYS predicate
T823SQL/JSON: PASSING clause
T824JSON_TABLE: specific PLAN clause
T825SQL/JSON: ON EMPTY and ON ERROR clauses
T826General value expression in ON ERROR or ON EMPTY clauses
T827JSON_TABLE: sibling NESTED COLUMNS clauses
T828JSON_QUERY
T829JSON_QUERY: array wrapper options
T830Enforcing unique keys in SQL/JSON constructor functions
T832SQL/JSON path language: item methoddatetime() not yet implemented
T838JSON_TABLE: PLAN DEFAULT clause
T839Formatted cast of datetimes to/from character strings
M001Datalinks
M002Datalinks via SQL/CLI
M003Datalinks via Embedded SQL
M004Foreign data supportpartially supported
M005Foreign schema support
M006GetSQLString routine
M007TransmitRequest
M009GetOpts and GetStatistics routines
M010Foreign data wrapper supportdifferent API
M011Datalinks via Ada
M012Datalinks via C
M013Datalinks via COBOL
M014Datalinks via Fortran
M015Datalinks via M
M016Datalinks via Pascal
M017Datalinks via PL/I
M018Foreign data wrapper interface routines in Ada
M019Foreign data wrapper interface routines in Cdifferent API
M020Foreign data wrapper interface routines in COBOL
M021Foreign data wrapper interface routines in Fortran
M022Foreign data wrapper interface routines in MUMPS
M023Foreign data wrapper interface routines in Pascal
M024Foreign data wrapper interface routines in PL/I
M030SQL-server foreign data support
M031Foreign data wrapper general routines
X012Multisets of XML type
X013Distinct types of XML type
X015Fields of XML type
X025XMLCast
X030XMLDocument
X038XMLText
X065XMLParse: BLOB input and CONTENT option
X066XMLParse: BLOB input and DOCUMENT option
X068XMLSerialize: BOM
X069XMLSerialize: INDENT
X073XMLSerialize: BLOB serialization and CONTENT option
X074XMLSerialize: BLOB serialization and DOCUMENT option
X075XMLSerialize: BLOB serialization
X076XMLSerialize: VERSION
X077XMLSerialize: explicit ENCODING option
X078XMLSerialize: explicit XML declaration
X080Namespaces in XML publishing
X081Query-level XML namespace declarations
X082XML namespace declarations in DML
X083XML namespace declarations in DDL
X084XML namespace declarations in compound statements
X085Predefined namespace prefixes
X086XML namespace declarations in XMLTable
X091XML content predicate
X096XMLExistsXPath 1.0 only
X100Host language support for XML: CONTENT option
X101Host language support for XML: DOCUMENT option
X110Host language support for XML: VARCHAR mapping
X111Host language support for XML: CLOB mapping
X112Host language support for XML: BLOB mapping
X113Host language support for XML: STRIP WHITESPACE option
X114Host language support for XML: PRESERVE WHITESPACE option
X131Query-level XMLBINARY clause
X132XMLBINARY clause in DML
X133XMLBINARY clause in DDL
X134XMLBINARY clause in compound statements
X135XMLBINARY clause in subqueries
X141IS VALID predicate: data-driven case
X142IS VALID predicate: ACCORDING TO clause
X143IS VALID predicate: ELEMENT clause
X144IS VALID predicate: schema location
X145IS VALID predicate outside check constraints
X151IS VALID predicate with DOCUMENT option
X152IS VALID predicate with CONTENT option
X153IS VALID predicate with SEQUENCE option
X155IS VALID predicate: NAMESPACE without ELEMENT clause
X157IS VALID predicate: NO NAMESPACE with ELEMENT clause
X160Basic Information Schema for registered XML Schemas
X161Advanced Information Schema for registered XML Schemas
X170XML null handling options
X171NIL ON NO CONTENT option
X181XML(DOCUMENT(UNTYPED)) type
X182XML(DOCUMENT(ANY)) type
X190XML(SEQUENCE) type
X191XML(DOCUMENT(XMLSCHEMA)) type
X192XML(CONTENT(XMLSCHEMA)) type
X200XMLQuery
X201XMLQuery: RETURNING CONTENT
X202XMLQuery: RETURNING SEQUENCE
X203XMLQuery: passing a context item
X204XMLQuery: initializing an XQuery variable
X205XMLQuery: EMPTY ON EMPTY option
X206XMLQuery: NULL ON EMPTY option
X211XML 1.1 support
X222XML passing mechanism BY REFparser accepts BY REF but ignores it; passing is always BY VALUE
X231XML(CONTENT(UNTYPED)) type
X232XML(CONTENT(ANY)) type
X241RETURNING CONTENT in XML publishing
X242RETURNING SEQUENCE in XML publishing
X251Persistent XML values of XML(DOCUMENT(UNTYPED)) type
X252Persistent XML values of XML(DOCUMENT(ANY)) type
X253Persistent XML values of XML(CONTENT(UNTYPED)) type
X254Persistent XML values of XML(CONTENT(ANY)) type
X255Persistent XML values of XML(SEQUENCE) type
X256Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type
X257Persistent XML values of XML(CONTENT(XMLSCHEMA)) type
X260XML type: ELEMENT clause
X261XML type: NAMESPACE without ELEMENT clause
X263XML type: NO NAMESPACE with ELEMENT clause
X264XML type: schema location
X271XMLValidate: data-driven case
X272XMLValidate: ACCORDING TO clause
X273XMLValidate: ELEMENT clause
X274XMLValidate: schema location
X281XMLValidate with DOCUMENT option
X282XMLValidate with CONTENT option
X283XMLValidate with SEQUENCE option
X284XMLValidate: NAMESPACE without ELEMENT clause
X286XMLValidate: NO NAMESPACE with ELEMENT clause
X300XMLTableXPath 1.0 only
X305XMLTable: initializing an XQuery variable

AltStyle によって変換されたページ (->オリジナル) /