PostgreSQL 13.1 中文入门教程 PostgreSQL 已支持特性

2024-02-25 开发教程 PostgreSQL 13.1 中文入门教程 匿名 3
标识符核心描述注释
B012Embedded C
B021Direct SQL
E011CoreNumeric data types
E011-01CoreINTEGER and SMALLINT data types
E011-02CoreREAL, DOUBLE PRECISION, and FLOAT data types
E011-03CoreDECIMAL and NUMERIC data types
E011-04CoreArithmetic operators
E011-05CoreNumeric comparison
E011-06CoreImplicit casting among the numeric data types
E021CoreCharacter data types
E021-01CoreCHARACTER data type
E021-02CoreCHARACTER VARYING data type
E021-03CoreCharacter literals
E021-04CoreCHARACTER_LENGTH functiontrims trailing spaces from CHARACTER values before counting
E021-05CoreOCTET_LENGTH function
E021-06CoreSUBSTRING function
E021-07CoreCharacter concatenation
E021-08CoreUPPER and LOWER functions
E021-09CoreTRIM function
E021-10CoreImplicit casting among the character string types
E021-11CorePOSITION function
E021-12CoreCharacter comparison
E031CoreIdentifiers
E031-01CoreDelimited identifiers
E031-02CoreLower case identifiers
E031-03CoreTrailing underscore
E051CoreBasic query specification
E051-01CoreSELECT DISTINCT
E051-02CoreGROUP BY clause
E051-04CoreGROUP BY can contain columns not in <select list>
E051-05CoreSelect list items can be renamed
E051-06CoreHAVING clause
E051-07CoreQualified * in select list
E051-08CoreCorrelation names in the FROM clause
E051-09CoreRename columns in the FROM clause
E061CoreBasic predicates and search conditions
E061-01CoreComparison predicate
E061-02CoreBETWEEN predicate
E061-03CoreIN predicate with list of values
E061-04CoreLIKE predicate
E061-05CoreLIKE predicate ESCAPE clause
E061-06CoreNULL predicate
E061-07CoreQuantified comparison predicate
E061-08CoreEXISTS predicate
E061-09CoreSubqueries in comparison predicate
E061-11CoreSubqueries in IN predicate
E061-12CoreSubqueries in quantified comparison predicate
E061-13CoreCorrelated subqueries
E061-14CoreSearch condition
E071CoreBasic query expressions
E071-01CoreUNION DISTINCT table operator
E071-02CoreUNION ALL table operator
E071-03CoreEXCEPT DISTINCT table operator
E071-05CoreColumns combined via table operators need not have exactly the same data type
E071-06CoreTable operators in subqueries
E081CoreBasic Privileges
E081-01CoreSELECT privilege
E081-02CoreDELETE privilege
E081-03CoreINSERT privilege at the table level
E081-04CoreUPDATE privilege at the table level
E081-05CoreUPDATE privilege at the column level
E081-06CoreREFERENCES privilege at the table level
E081-07CoreREFERENCES privilege at the column level
E081-08CoreWITH GRANT OPTION
E081-09CoreUSAGE privilege
E081-10CoreEXECUTE privilege
E091CoreSet functions
E091-01CoreAVG
E091-02CoreCOUNT
E091-03CoreMAX
E091-04CoreMIN
E091-05CoreSUM
E091-06CoreALL quantifier
E091-07CoreDISTINCT quantifier
E101CoreBasic data manipulation
E101-01CoreINSERT statement
E101-03CoreSearched UPDATE statement
E101-04CoreSearched DELETE statement
E111CoreSingle row SELECT statement
E121CoreBasic cursor support
E121-01CoreDECLARE CURSOR
E121-02CoreORDER BY columns need not be in select list
E121-03CoreValue expressions in ORDER BY clause
E121-04CoreOPEN statement
E121-06CorePositioned UPDATE statement
E121-07CorePositioned DELETE statement
E121-08CoreCLOSE statement
E121-10CoreFETCH statement implicit NEXT
E121-17CoreWITH HOLD cursors
E131CoreNull value support (nulls in lieu of values)
E141CoreBasic integrity constraints
E141-01CoreNOT NULL constraints
E141-02CoreUNIQUE constraints of NOT NULL columns
E141-03CorePRIMARY KEY constraints
E141-04CoreBasic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action
E141-06CoreCHECK constraints
E141-07CoreColumn defaults
E141-08CoreNOT NULL inferred on PRIMARY KEY
E141-10CoreNames in a foreign key can be specified in any order
E151CoreTransaction support
E151-01CoreCOMMIT statement
E151-02CoreROLLBACK statement
E152CoreBasic SET TRANSACTION statement
E152-01CoreSET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause
E152-02CoreSET TRANSACTION statement: READ ONLY and READ WRITE clauses
E153CoreUpdatable queries with subqueries
E161CoreSQL comments using leading double minus
E171CoreSQLSTATE support
E182CoreHost language binding
F021CoreBasic information schema
F021-01CoreCOLUMNS view
F021-02CoreTABLES view
F021-03CoreVIEWS view
F021-04CoreTABLE_CONSTRAINTS view
F021-05CoreREFERENTIAL_CONSTRAINTS view
F021-06CoreCHECK_CONSTRAINTS view
F031CoreBasic schema manipulation
F031-01CoreCREATE TABLE statement to create persistent base tables
F031-02CoreCREATE VIEW statement
F031-03CoreGRANT statement
F031-04CoreALTER TABLE statement: ADD COLUMN clause
F031-13CoreDROP TABLE statement: RESTRICT clause
F031-16CoreDROP VIEW statement: RESTRICT clause
F031-19CoreREVOKE statement: RESTRICT clause
F032CASCADE drop behavior
F033ALTER TABLE statement: DROP COLUMN clause
F034Extended REVOKE statement
F034-01REVOKE statement performed by other than the owner of a schema object
F034-02REVOKE statement: GRANT OPTION FOR clause
F034-03REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION
F041CoreBasic joined table
F041-01CoreInner join (but not necessarily the INNER keyword)
F041-02CoreINNER keyword
F041-03CoreLEFT OUTER JOIN
F041-04CoreRIGHT OUTER JOIN
F041-05CoreOuter joins can be nested
F041-07CoreThe inner table in a left or right outer join can also be used in an inner join
F041-08CoreAll comparison operators are supported (rather than just =)
F051CoreBasic date and time
F051-01CoreDATE data type (including support of DATE literal)
F051-02CoreTIME data type (including support of TIME literal) with fractional seconds precision of at least 0
F051-03CoreTIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6
F051-04CoreComparison predicate on DATE, TIME, and TIMESTAMP data types
F051-05CoreExplicit CAST between datetime types and character string types
F051-06CoreCURRENT_DATE
F051-07CoreLOCALTIME
F051-08CoreLOCALTIMESTAMP
F052Intervals and datetime arithmetic
F053OVERLAPS predicate
F081CoreUNION and EXCEPT in views
F111Isolation levels other than SERIALIZABLE
F111-01READ UNCOMMITTED isolation level
F111-02READ COMMITTED isolation level
F111-03REPEATABLE READ isolation level
F131CoreGrouped operations
F131-01CoreWHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
F131-02CoreMultiple tables supported in queries with grouped views
F131-03CoreSet functions supported in queries with grouped views
F131-04CoreSubqueries with GROUP BY and HAVING clauses and grouped views
F131-05CoreSingle row SELECT with GROUP BY and HAVING clauses and grouped views
F171Multiple schemas per user
F181CoreMultiple module support
F191Referential delete actions
F200TRUNCATE TABLE statement
F201CoreCAST function
F202TRUNCATE TABLE: identity column restart option
F221CoreExplicit defaults
F222INSERT statement: DEFAULT VALUES clause
F231Privilege tables
F231-01TABLE_PRIVILEGES view
F231-02COLUMN_PRIVILEGES view
F231-03USAGE_PRIVILEGES view
F251Domain support
F261CoreCASE expression
F261-01CoreSimple CASE
F261-02CoreSearched CASE
F261-03CoreNULLIF
F261-04CoreCOALESCE
F262Extended CASE expression
F271Compound character literals
F281LIKE enhancements
F302INTERSECT table operator
F302-01INTERSECT DISTINCT table operator
F302-02INTERSECT ALL table operator
F304EXCEPT ALL table operator
F311CoreSchema definition statement
F311-01CoreCREATE SCHEMA
F311-02CoreCREATE TABLE for persistent base tables
F311-03CoreCREATE VIEW
F311-04CoreCREATE VIEW: WITH CHECK OPTION
F311-05CoreGRANT statement
F321User authorization
F361Subprogram support
F381Extended schema manipulation
F381-01ALTER TABLE statement: ALTER COLUMN clause
F381-02ALTER TABLE statement: ADD CONSTRAINT clause
F381-03ALTER TABLE statement: DROP CONSTRAINT clause
F382Alter column data type
F383Set column not null clause
F384Drop identity property clause
F385Drop column generation expression clause
F386Set identity column generation clause
F391Long identifiers
F392Unicode escapes in identifiers
F393Unicode escapes in literals
F394Optional normal form specification
F401Extended joined table
F401-01NATURAL JOIN
F401-02FULL OUTER JOIN
F401-04CROSS JOIN
F402Named column joins for LOBs, arrays, and multisets
F411Time zone specificationdifferences regarding literal interpretation
F421National character
F431Read-only scrollable cursors
F431-01FETCH with explicit NEXT
F431-02FETCH FIRST
F431-03FETCH LAST
F431-04FETCH PRIOR
F431-05FETCH ABSOLUTE
F431-06FETCH RELATIVE
F441Extended set function support
F442Mixed column references in set functions
F471CoreScalar subquery values
F481CoreExpanded NULL predicate
F491Constraint management
F501CoreFeatures and conformance views
F501-01CoreSQL_FEATURES view
F501-02CoreSQL_SIZING view
F502Enhanced documentation tables
F531Temporary tables
F555Enhanced seconds precision
F561Full value expressions
F571Truth value tests
F591Derived tables
F611Indicator data types
F641Row and table constructors
F651Catalog name qualifiers
F661Simple tables
F672Retrospective check constraints
F690Collation supportbut no character set support
F692Extended collation support
F701Referential update actions
F711ALTER domain
F731INSERT column privileges
F751View CHECK enhancements
F761Session management
F762CURRENT_CATALOG
F763CURRENT_SCHEMA
F771Connection management
F781Self-referencing operations
F791Insensitive cursors
F801Full set function
F850Top-level <order by clause> in <query expression>
F851<order by clause> in subqueries
F852Top-level <order by clause> in views
F855Nested <order by clause> in <query expression>
F856Nested <fetch first clause> in <query expression>
F857Top-level <fetch first clause> in <query expression>
F858<fetch first clause> in subqueries
F859Top-level <fetch first clause> in views
F860<fetch first row count> in <fetch first clause>
F861Top-level <result offset clause> in <query expression>
F862<result offset clause> in subqueries
F863Nested <result offset clause> in <query expression>
F864Top-level <result offset clause> in views
F865<offset row count> in <result offset clause>
F867FETCH FIRST clause: WITH TIES option
S071SQL paths in function and type name resolution
S092Arrays of user-defined types
S095Array constructors by query
S096Optional array bounds
S098ARRAY_AGG
S111ONLY in query expressions
S201SQL-invoked routines on arrays
S201-01Array parameters
S201-02Array as result type of functions
S211User-defined cast functions
S301Enhanced UNNEST
T031BOOLEAN data type
T071BIGINT data type
T121WITH (excluding RECURSIVE) in query expression
T122WITH (excluding RECURSIVE) in subquery
T131Recursive query
T132Recursive query in subquery
T141SIMILAR predicate
T151DISTINCT predicate
T152DISTINCT predicate with negation
T171LIKE clause in table definition
T172AS subquery clause in table definition
T173Extended LIKE clause in table definition
T174Identity columns
T177Sequence generator support: simple restart option
T178Identity columns: simple restart option
T191Referential action RESTRICT
T201Comparable data types for referential constraints
T211-01Triggers activated on UPDATE, INSERT, or DELETE of one base table
T211-02BEFORE triggers
T211-03AFTER triggers
T211-04FOR EACH ROW triggers
T211-05Ability to specify a search condition that must be true before the trigger is invoked
T211-07TRIGGER privilege
T212Enhanced trigger capability
T213INSTEAD OF triggers
T231Sensitive cursors
T241START TRANSACTION statement
T261Chained transactions
T271Savepoints
T281SELECT privilege with column granularity
T285Enhanced derived column names
T312OVERLAY function
T321-01CoreUser-defined functions with no overloading
T321-02CoreUser-defined stored procedures with no overloading
T321-03CoreFunction invocation
T321-04CoreCALL statement
T321-06CoreROUTINES view
T321-07CorePARAMETERS view
T323Explicit security for external routines
T325Qualified SQL parameter references
T331Basic roles
T341Overloading of SQL-invoked functions and procedures
T351Bracketed SQL comments (/*...*/ comments)
T431Extended grouping capabilities
T432Nested and concatenated GROUPING SETS
T433Multiargument GROUPING function
T441ABS and MOD functions
T461Symmetric BETWEEN predicate
T491LATERAL derived table
T501Enhanced EXISTS predicate
T521Named arguments in CALL statement
T523Default values for INOUT parameters of SQL-invoked procedures
T524Named arguments in routine invocations other than a CALL statement
T525Default values for parameters of SQL-invoked functions
T551Optional key words for default syntax
T581Regular expression substring function
T591UNIQUE constraints of possibly null columns
T611Elementary OLAP operations
T612Advanced OLAP operations
T613Sampling
T614NTILE function
T615LEAD and LAG functions
T617FIRST_VALUE and LAST_VALUE function
T620WINDOW clause: GROUPS option
T621Enhanced numeric functions
T622Trigonometric functions
T623General logarithm functions
T624Common logarithm functions
T631CoreIN predicate with one list element
T651SQL-schema statements in SQL routines
T653SQL-schema statements in external routines
T655Cyclically dependent routines
T831SQL/JSON path language: strict mode
T832SQL/JSON path language: item method
T833SQL/JSON path language: multiple subscripts
T834SQL/JSON path language: wildcard member accessor
T835SQL/JSON path language: filter expressions
T836SQL/JSON path language: starts with predicate
T837SQL/JSON path language: regex_like predicate
X010XML type
X011Arrays of XML type
X014Attributes of XML type
X016Persistent XML values
X020XMLConcat
X031XMLElement
X032XMLForest
X034XMLAgg
X035XMLAgg: ORDER BY option
X036XMLComment
X037XMLPI
X040Basic table mapping
X041Basic table mapping: nulls absent
X042Basic table mapping: null as nil
X043Basic table mapping: table as forest
X044Basic table mapping: table as element
X045Basic table mapping: with target namespace
X046Basic table mapping: data mapping
X047Basic table mapping: metadata mapping
X048Basic table mapping: base64 encoding of binary strings
X049Basic table mapping: hex encoding of binary strings
X050Advanced table mapping
X051Advanced table mapping: nulls absent
X052Advanced table mapping: null as nil
X053Advanced table mapping: table as forest
X054Advanced table mapping: table as element
X055Advanced table mapping: with target namespace
X056Advanced table mapping: data mapping
X057Advanced table mapping: metadata mapping
X058Advanced table mapping: base64 encoding of binary strings
X059Advanced table mapping: hex encoding of binary strings
X060XMLParse: character string input and CONTENT option
X061XMLParse: character string input and DOCUMENT option
X070XMLSerialize: character string serialization and CONTENT option
X071XMLSerialize: character string serialization and DOCUMENT option
X072XMLSerialize: character string serialization
X090XML document predicate
X120XML parameters in SQL routines
X121XML parameters in external routines
X221XML passing mechanism BY VALUE
X301XMLTable: derived column list option
X302XMLTable: ordinality column option
X303XMLTable: column default option
X304XMLTable: passing a context itemmust be XML DOCUMENT
X400Name and identifier mapping
X410Alter column data type: XML type