9.3 9.4 9.5 9.6 10 11 12 13 14 Current(15)
阿里云PostgreSQL 问题报告 纠错本页面
PostgreSQL 9.6.0 手册
上一页上一级附录 D. SQL 符合性下一页

D.2. 未支持特性

下列定义在SQL:2011中的特性还没有在这个PostgreSQL发行中被实现。在一些情况中,有等效的功能可用。

标识符包描述注释
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
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
F202TRUNCATE TABLE: identity column restart option
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
F384Drop identity property clause
F385Drop column generation expression clause
F386Set identity column generation clause
F394Optional normal form specification
F403Partitioned joined tables
F451Character set definition
F461Named character sets
F492Optional table constraint enforcement
F521Enhanced integrity managementAssertions
F671Enhanced integrity managementSubqueries in CHECKintentionally omitted
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
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
T052MAX and MIN for row types
T053Explicit aliases for all-fields reference
T061UCS support
T101Enhanced nullability determination
T111Updatable joins, unions, and columns
T174Identity columns
T175Generated columns
T176Sequence generator support
T177Sequence generator support: simple restart option
T178Identity columns: simple restart option
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
T261Chained transactions
T272Enhanced savepoint management
T285Enhanced derived column names
T301Functional dependenciespartially supported
T321CoreBasic SQL-invoked routines
T321-02CoreUser-defined stored procedures with no overloading
T321-04CoreCALL statement
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
T521Named arguments in CALL statement
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
T620WINDOW clause: GROUPS option
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
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
X014Attributes 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
X096XMLExists
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
X221XML passing mechanism BY VALUE
X222XML passing mechanism BY REF
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
X300XMLTable
X301XMLTable: derived column list option
X302XMLTable: ordinality column option
X303XMLTable: column default option
X304XMLTable: passing a context item
X305XMLTable: initializing an XQuery variable

上一页起始页下一页
已支持特性上一级版本说明
<
/BODY>

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