PostgreSQL

PostgreSQL Elephant Logo

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

Home

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