PostgreSQL
D.1. Supported Features
Identifier | Package | Description | Comment |
---|---|---|---|
B012 |
Embedded C |
||
B021 |
Direct SQL |
||
E011 |
Core |
Numeric data types |
|
E011-01 |
Core |
INTEGER and SMALLINT data types |
|
E011-02 |
Core |
REAL, DOUBLE PRECISION, and FLOAT data types |
|
E011-03 |
Core |
DECIMAL and NUMERIC data types |
|
E011-04 |
Core |
Arithmetic operators |
|
E011-05 |
Core |
Numeric comparison |
|
E011-06 |
Core |
Implicit casting among the numeric data types |
|
E021 |
Core |
Character data types |
|
E021-01 |
Core |
CHARACTER data type |
|
E021-02 |
Core |
CHARACTER VARYING data type |
|
E021-03 |
Core |
Character literals |
|
E021-04 |
Core |
CHARACTER_LENGTH function |
trims trailing spaces from CHARACTER values before counting |
E021-05 |
Core |
OCTET_LENGTH function |
|
E021-06 |
Core |
SUBSTRING function |
|
E021-07 |
Core |
Character concatenation |
|
E021-08 |
Core |
UPPER and LOWER functions |
|
E021-09 |
Core |
TRIM function |
|
E021-10 |
Core |
Implicit casting among the character string types |
|
E021-11 |
Core |
POSITION function |
|
E021-12 |
Core |
Character comparison |
|
E031 |
Core |
Identifiers |
|
E031-01 |
Core |
Delimited identifiers |
|
E031-02 |
Core |
Lower case identifiers |
|
E031-03 |
Core |
Trailing underscore |
|
E051 |
Core |
Basic query specification |
|
E051-01 |
Core |
SELECT DISTINCT |
|
E051-02 |
Core |
GROUP BY clause |
|
E051-04 |
Core |
GROUP BY can contain columns not in <select list> |
|
E051-05 |
Core |
Select list items can be renamed |
|
E051-06 |
Core |
HAVING clause |
|
E051-07 |
Core |
Qualified * in select list |
|
E051-08 |
Core |
Correlation names in the FROM clause |
|
E051-09 |
Core |
Rename columns in the FROM clause |
|
E061 |
Core |
Basic predicates and search conditions |
|
E061-01 |
Core |
Comparison predicate |
|
E061-02 |
Core |
BETWEEN predicate |
|
E061-03 |
Core |
IN predicate with list of values |
|
E061-04 |
Core |
LIKE predicate |
|
E061-05 |
Core |
LIKE predicate ESCAPE clause |
|
E061-06 |
Core |
NULL predicate |
|
E061-07 |
Core |
Quantified comparison predicate |
|
E061-08 |
Core |
EXISTS predicate |
|
E061-09 |
Core |
Subqueries in comparison predicate |
|
E061-11 |
Core |
Subqueries in IN predicate |
|
E061-12 |
Core |
Subqueries in quantified comparison predicate |
|
E061-13 |
Core |
Correlated subqueries |
|
E061-14 |
Core |
Search condition |
|
E071 |
Core |
Basic query expressions |
|
E071-01 |
Core |
UNION DISTINCT table operator |
|
E071-02 |
Core |
UNION ALL table operator |
|
E071-03 |
Core |
EXCEPT DISTINCT table operator |
|
E071-05 |
Core |
Columns combined via table operators need not have exactly the same data type |
|
E071-06 |
Core |
Table operators in subqueries |
|
E081 |
Core |
Basic Privileges |
|
E081-01 |
Core |
SELECT privilege |
|
E081-02 |
Core |
DELETE privilege |
|
E081-03 |
Core |
INSERT privilege at the table level |
|
E081-04 |
Core |
UPDATE privilege at the table level |
|
E081-05 |
Core |
UPDATE privilege at the column level |
|
E081-06 |
Core |
REFERENCES privilege at the table level |
|
E081-07 |
Core |
REFERENCES privilege at the column level |
|
E081-08 |
Core |
WITH GRANT OPTION |
|
E081-09 |
Core |
USAGE privilege |
|
E081-10 |
Core |
EXECUTE privilege |
|
E091 |
Core |
Set functions |
|
E091-01 |
Core |
AVG |
|
E091-02 |
Core |
COUNT |
|
E091-03 |
Core |
MAX |
|
E091-04 |
Core |
MIN |
|
E091-05 |
Core |
SUM |
|
E091-06 |
Core |
ALL quantifier |
|
E091-07 |
Core |
DISTINCT quantifier |
|
E101 |
Core |
Basic data manipulation |
|
E101-01 |
Core |
INSERT statement |
|
E101-03 |
Core |
Searched UPDATE statement |
|
E101-04 |
Core |
Searched DELETE statement |
|
E111 |
Core |
Single row SELECT statement |
|
E121 |
Core |
Basic cursor support |
|
E121-01 |
Core |
DECLARE CURSOR |
|
E121-02 |
Core |
ORDER BY columns need not be in select list |
|
E121-03 |
Core |
Value expressions in ORDER BY clause |
|
E121-04 |
Core |
OPEN statement |
|
E121-06 |
Core |
Positioned UPDATE statement |
|
E121-07 |
Core |
Positioned DELETE statement |
|
E121-08 |
Core |
CLOSE statement |
|
E121-10 |
Core |
FETCH statement implicit NEXT |
|
E121-17 |
Core |
WITH HOLD cursors |
|
E131 |
Core |
Null value support (nulls in lieu of values) |
|
E141 |
Core |
Basic integrity constraints |
|
E141-01 |
Core |
NOT NULL constraints |
|
E141-02 |
Core |
UNIQUE constraints of NOT NULL columns |
|
E141-03 |
Core |
PRIMARY KEY constraints |
|
E141-04 |
Core |
Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action |
|
E141-06 |
Core |
CHECK constraints |
|
E141-07 |
Core |
Column defaults |
|
E141-08 |
Core |
NOT NULL inferred on PRIMARY KEY |
|
E141-10 |
Core |
Names in a foreign key can be specified in any order |
|
E151 |
Core |
Transaction support |
|
E151-01 |
Core |
COMMIT statement |
|
E151-02 |
Core |
ROLLBACK statement |
|
E152 |
Core |
Basic SET TRANSACTION statement |
|
E152-01 |
Core |
SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause |
|
E152-02 |
Core |
SET TRANSACTION statement: READ ONLY and READ WRITE clauses |
|
E153 |
Core |
Updatable queries with subqueries |
|
E161 |
Core |
SQL comments using leading double minus |
|
E171 |
Core |
SQLSTATE support |
|
F021 |
Core |
Basic information schema |
|
F021-01 |
Core |
COLUMNS view |
|
F021-02 |
Core |
TABLES view |
|
F021-03 |
Core |
VIEWS view |
|
F021-04 |
Core |
TABLE_CONSTRAINTS view |
|
F021-05 |
Core |
REFERENTIAL_CONSTRAINTS view |
|
F021-06 |
Core |
CHECK_CONSTRAINTS view |
|
F031 |
Core |
Basic schema manipulation |
|
F031-01 |
Core |
CREATE TABLE statement to create persistent base tables |
|
F031-02 |
Core |
CREATE VIEW statement |
|
F031-03 |
Core |
GRANT statement |
|
F031-04 |
Core |
ALTER TABLE statement: ADD COLUMN clause |
|
F031-13 |
Core |
DROP TABLE statement: RESTRICT clause |
|
F031-16 |
Core |
DROP VIEW statement: RESTRICT clause |
|
F031-19 |
Core |
REVOKE statement: RESTRICT clause |
|
F032 |
CASCADE drop behavior |
||
F033 |
ALTER TABLE statement: DROP COLUMN clause |
||
F034 |
Extended REVOKE statement |
||
F034-01 |
REVOKE statement performed by other than the owner of a schema object |
||
F034-02 |
REVOKE statement: GRANT OPTION FOR clause |
||
F034-03 |
REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION |
||
F041 |
Core |
Basic joined table |
|
F041-01 |
Core |
Inner join (but not necessarily the INNER keyword) |
|
F041-02 |
Core |
INNER keyword |
|
F041-03 |
Core |
LEFT OUTER JOIN |
|
F041-04 |
Core |
RIGHT OUTER JOIN |
|
F041-05 |
Core |
Outer joins can be nested |
|
F041-07 |
Core |
The inner table in a left or right outer join can also be used in an inner join |
|
F041-08 |
Core |
All comparison operators are supported (rather than just =) |
|
F051 |
Core |
Basic date and time |
|
F051-01 |
Core |
DATE data type (including support of DATE literal) |
|
F051-02 |
Core |
TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 |
|
F051-03 |
Core |
TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 |
|
F051-04 |
Core |
Comparison predicate on DATE, TIME, and TIMESTAMP data types |
|
F051-05 |
Core |
Explicit CAST between datetime types and character string types |
|
F051-06 |
Core |
CURRENT_DATE |
|
F051-07 |
Core |
LOCALTIME |
|
F051-08 |
Core |
LOCALTIMESTAMP |
|
F052 |
Enhanced datetime facilities |
Intervals and datetime arithmetic |
|
F053 |
OVERLAPS predicate |
||
F081 |
Core |
UNION and EXCEPT in views |
|
F111 |
Isolation levels other than SERIALIZABLE |
||
F111-01 |
READ UNCOMMITTED isolation level |
||
F111-02 |
READ COMMITTED isolation level |
||
F111-03 |
REPEATABLE READ isolation level |
||
F131 |
Core |
Grouped operations |
|
F131-01 |
Core |
WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views |
|
F131-02 |
Core |
Multiple tables supported in queries with grouped views |
|
F131-03 |
Core |
Set functions supported in queries with grouped views |
|
F131-04 |
Core |
Subqueries with GROUP BY and HAVING clauses and grouped views |
|
F131-05 |
Core |
Single row SELECT with GROUP BY and HAVING clauses and grouped views |
|
F171 |
Multiple schemas per user |
||
F191 |
Enhanced integrity management |
Referential delete actions |
|
F200 |
TRUNCATE TABLE statement |
||
F201 |
Core |
CAST function |
|
F202 |
TRUNCATE TABLE: identity column restart option |
||
F221 |
Core |
Explicit defaults |
|
F222 |
INSERT statement: DEFAULT VALUES clause |
||
F231 |
Privilege tables |
||
F231-01 |
TABLE_PRIVILEGES view |
||
F231-02 |
COLUMN_PRIVILEGES view |
||
F231-03 |
USAGE_PRIVILEGES view |
||
F251 |
Domain support |
||
F261 |
Core |
CASE expression |
|
F261-01 |
Core |
Simple CASE |
|
F261-02 |
Core |
Searched CASE |
|
F261-03 |
Core |
NULLIF |
|
F261-04 |
Core |
COALESCE |
|
F262 |
Extended CASE expression |
||
F271 |
Compound character literals |
||
F281 |
LIKE enhancements |
||
F302 |
INTERSECT table operator |
||
F302-01 |
INTERSECT DISTINCT table operator |
||
F302-02 |
INTERSECT ALL table operator |
||
F304 |
EXCEPT ALL table operator |
||
F311-01 |
Core |
CREATE SCHEMA |
|
F311-02 |
Core |
CREATE TABLE for persistent base tables |
|
F311-03 |
Core |
CREATE VIEW |
|
F311-04 |
Core |
CREATE VIEW: WITH CHECK OPTION |
|
F311-05 |
Core |
GRANT statement |
|
F321 |
User authorization |
||
F361 |
Subprogram support |
||
F381 |
Extended schema manipulation |
||
F381-01 |
ALTER TABLE statement: ALTER COLUMN clause |
||
F381-02 |
ALTER TABLE statement: ADD CONSTRAINT clause |
||
F381-03 |
ALTER TABLE statement: DROP CONSTRAINT clause |
||
F382 |
Alter column data type |
||
F383 |
Set column not null clause |
||
F384 |
Drop identity property clause |
||
F386 |
Set identity column generation clause |
||
F391 |
Long identifiers |
||
F392 |
Unicode escapes in identifiers |
||
F393 |
Unicode escapes in literals |
||
F401 |
Extended joined table |
||
F401-01 |
NATURAL JOIN |
||
F401-02 |
FULL OUTER JOIN |
||
F401-04 |
CROSS JOIN |
||
F402 |
Named column joins for LOBs, arrays, and multisets |
||
F411 |
Enhanced datetime facilities |
Time zone specification |
differences regarding literal interpretation |
F421 |
National character |
||
F431 |
Read-only scrollable cursors |
||
F431-01 |
FETCH with explicit NEXT |
||
F431-02 |
FETCH FIRST |
||
F431-03 |
FETCH LAST |
||
F431-04 |
FETCH PRIOR |
||
F431-05 |
FETCH ABSOLUTE |
||
F431-06 |
FETCH RELATIVE |
||
F441 |
Extended set function support |
||
F442 |
Mixed column references in set functions |
||
F471 |
Core |
Scalar subquery values |
|
F481 |
Core |
Expanded NULL predicate |
|
F491 |
Enhanced integrity management |
Constraint management |
|
F501 |
Core |
Features and conformance views |
|
F501-01 |
Core |
SQL_FEATURES view |
|
F501-02 |
Core |
SQL_SIZING view |
|
F501-03 |
Core |
SQL_LANGUAGES view |
|
F502 |
Enhanced documentation tables |
||
F502-01 |
SQL_SIZING_PROFILES view |
||
F502-02 |
SQL_IMPLEMENTATION_INFO view |
||
F502-03 |
SQL_PACKAGES view |
||
F531 |
Temporary tables |
||
F555 |
Enhanced datetime facilities |
Enhanced seconds precision |
|
F561 |
Full value expressions |
||
F571 |
Truth value tests |
||
F591 |
Derived tables |
||
F611 |
Indicator data types |
||
F641 |
Row and table constructors |
||
F651 |
Catalog name qualifiers |
||
F661 |
Simple tables |
||
F672 |
Retrospective check constraints |
||
F690 |
Collation support |
but no character set support |
|
F692 |
Extended collation support |
||
F701 |
Enhanced integrity management |
Referential update actions |
|
F711 |
ALTER domain |
||
F731 |
INSERT column privileges |
||
F751 |
View CHECK enhancements |
||
F761 |
Session management |
||
F762 |
CURRENT_CATALOG |
||
F763 |
CURRENT_SCHEMA |
||
F771 |
Connection management |
||
F781 |
Self-referencing operations |
||
F791 |
Insensitive cursors |
||
F801 |
Full set function |
||
F850 |
Top-level <order by clause> in <query expression> |
||
F851 |
<order by clause> in subqueries |
||
F852 |
Top-level <order by clause> in views |
||
F855 |
Nested <order by clause> in <query expression> |
||
F856 |
Nested <fetch first clause> in <query expression> |
||
F857 |
Top-level <fetch first clause> in <query expression> |
||
F858 |
<fetch first clause> in subqueries |
||
F859 |
Top-level <fetch first clause> in views |
||
F860 |
<fetch first row count> in <fetch first clause> |
||
F861 |
Top-level <result offset clause> in <query expression> |
||
F862 |
<result offset clause> in subqueries |
||
F863 |
Nested <result offset clause> in <query expression> |
||
F864 |
Top-level <result offset clause> in views |
||
F865 |
<offset row count> in <result offset clause> |
||
S071 |
Enhanced object support |
SQL paths in function and type name resolution |
|
S092 |
Arrays of user-defined types |
||
S095 |
Array constructors by query |
||
S096 |
Optional array bounds |
||
S098 |
ARRAY_AGG |
||
S111 |
Enhanced object support |
ONLY in query expressions |
|
S201 |
SQL-invoked routines on arrays |
||
S201-01 |
Array parameters |
||
S201-02 |
Array as result type of functions |
||
S211 |
Enhanced object support |
User-defined cast functions |
|
S301 |
Enhanced UNNEST |
||
T031 |
BOOLEAN data type |
||
T071 |
BIGINT data type |
||
T121 |
WITH (excluding RECURSIVE) in query expression |
||
T122 |
WITH (excluding RECURSIVE) in subquery |
||
T131 |
Recursive query |
||
T132 |
Recursive query in subquery |
||
T141 |
SIMILAR predicate |
||
T151 |
DISTINCT predicate |
||
T152 |
DISTINCT predicate with negation |
||
T171 |
LIKE clause in table definition |
||
T172 |
AS subquery clause in table definition |
||
T173 |
Extended LIKE clause in table definition |
||
T174 |
Identity columns |
||
T177 |
Sequence generator support: simple restart option |
||
T178 |
Identity columns: simple restart option |
||
T191 |
Enhanced integrity management |
Referential action RESTRICT |
|
T201 |
Enhanced integrity management |
Comparable data types for referential constraints |
|
T211-01 |
Active database, Enhanced integrity management |
Triggers activated on UPDATE, INSERT, or DELETE of one base table |
|
T211-02 |
Active database, Enhanced integrity management |
BEFORE triggers |
|
T211-03 |
Active database, Enhanced integrity management |
AFTER triggers |
|
T211-04 |
Active database, Enhanced integrity management |
FOR EACH ROW triggers |
|
T211-05 |
Active database, Enhanced integrity management |
Ability to specify a search condition that must be true before the trigger is invoked |
|
T211-07 |
Active database, Enhanced integrity management |
TRIGGER privilege |
|
T212 |
Enhanced integrity management |
Enhanced trigger capability |
|
T213 |
INSTEAD OF triggers |
||
T231 |
Sensitive cursors |
||
T241 |
START TRANSACTION statement |
||
T261 |
Chained transactions |
||
T271 |
Savepoints |
||
T281 |
SELECT privilege with column granularity |
||
T285 |
Enhanced derived column names |
||
T312 |
OVERLAY function |
||
T321-01 |
Core |
User-defined functions with no overloading |
|
T321-02 |
Core |
User-defined stored procedures with no overloading |
|
T321-03 |
Core |
Function invocation |
|
T321-04 |
Core |
CALL statement |
|
T321-06 |
Core |
ROUTINES view |
|
T321-07 |
Core |
PARAMETERS view |
|
T323 |
Explicit security for external routines |
||
T325 |
Qualified SQL parameter references |
||
T331 |
Basic roles |
||
T341 |
Overloading of SQL-invoked functions and procedures |
||
T351 |
Bracketed SQL comments (/…/ comments) |
||
T431 |
OLAP |
Extended grouping capabilities |
|
T432 |
Nested and concatenated GROUPING SETS |
||
T433 |
Multiargument GROUPING function |
||
T441 |
ABS and MOD functions |
||
T461 |
Symmetric BETWEEN predicate |
||
T491 |
LATERAL derived table |
||
T501 |
Enhanced EXISTS predicate |
||
T521 |
Named arguments in CALL statement |
||
T523 |
Default values for INOUT parameters of SQL-invoked procedures |
||
T524 |
Named arguments in routine invocations other than a CALL statement |
||
T525 |
Default values for parameters of SQL-invoked functions |
||
T551 |
Optional key words for default syntax |
||
T581 |
Regular expression substring function |
||
T591 |
UNIQUE constraints of possibly null columns |
||
T611 |
OLAP |
Elementary OLAP operations |
|
T613 |
Sampling |
||
T614 |
NTILE function |
||
T615 |
LEAD and LAG functions |
||
T617 |
FIRST_VALUE and LAST_VALUE function |
||
T620 |
WINDOW clause: GROUPS option |
||
T621 |
Enhanced numeric functions |
||
T622 |
Trigonometric functions |
||
T623 |
General logarithm functions |
||
T624 |
Common logarithm functions |
||
T631 |
Core |
IN predicate with one list element |
|
T651 |
SQL-schema statements in SQL routines |
||
T655 |
Cyclically dependent routines |
||
T831 |
SQL/JSON path language: strict mode |
||
T833 |
SQL/JSON path language: multiple subscripts |
||
T834 |
SQL/JSON path language: wildcard member accessor |
||
T835 |
SQL/JSON path language: filter expressions |
||
T836 |
SQL/JSON path language: starts with predicate |
||
T837 |
SQL/JSON path language: regex_like predicate |
||
X010 |
XML type |
||
X011 |
Arrays of XML type |
||
X014 |
Attributes of XML type |
||
X016 |
Persistent XML values |
||
X020 |
XMLConcat |
||
X031 |
XMLElement |
||
X032 |
XMLForest |
||
X034 |
XMLAgg |
||
X035 |
XMLAgg: ORDER BY option |
||
X036 |
XMLComment |
||
X037 |
XMLPI |
||
X040 |
Basic table mapping |
||
X041 |
Basic table mapping: nulls absent |
||
X042 |
Basic table mapping: null as nil |
||
X043 |
Basic table mapping: table as forest |
||
X044 |
Basic table mapping: table as element |
||
X045 |
Basic table mapping: with target namespace |
||
X046 |
Basic table mapping: data mapping |
||
X047 |
Basic table mapping: metadata mapping |
||
X048 |
Basic table mapping: base64 encoding of binary strings |
||
X049 |
Basic table mapping: hex encoding of binary strings |
||
X050 |
Advanced table mapping |
||
X051 |
Advanced table mapping: nulls absent |
||
X052 |
Advanced table mapping: null as nil |
||
X053 |
Advanced table mapping: table as forest |
||
X054 |
Advanced table mapping: table as element |
||
X055 |
Advanced table mapping: with target namespace |
||
X056 |
Advanced table mapping: data mapping |
||
X057 |
Advanced table mapping: metadata mapping |
||
X058 |
Advanced table mapping: base64 encoding of binary strings |
||
X059 |
Advanced table mapping: hex encoding of binary strings |
||
X060 |
XMLParse: character string input and CONTENT option |
||
X061 |
XMLParse: character string input and DOCUMENT option |
||
X070 |
XMLSerialize: character string serialization and CONTENT option |
||
X071 |
XMLSerialize: character string serialization and DOCUMENT option |
||
X072 |
XMLSerialize: character string serialization |
||
X090 |
XML document predicate |
||
X120 |
XML parameters in SQL routines |
||
X121 |
XML parameters in external routines |
||
X221 |
XML passing mechanism BY VALUE |
||
X301 |
XMLTable: derived column list option |
||
X302 |
XMLTable: ordinality column option |
||
X303 |
XMLTable: column default option |
||
X304 |
XMLTable: passing a context item |
must be XML DOCUMENT |
|
X400 |
Name and identifier mapping |
||
X410 |
Alter column data type: XML type |
Prev | Up | Next |
---|---|---|
Appendix D. SQL Conformance |
D.2. Unsupported Features |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group