| B012 | | Embedded C | |
| B021 | | Direct SQL | |
| B128 | | Routine language 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 | |
| E182 | Core | Host language binding | |
| 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 | |
| F035 | | REVOKE with CASCADE | |
| F036 | | REVOKE statement performed by non-owner | |
| F037 | | REVOKE statement: GRANT OPTION FOR clause | |
| F038 | | REVOKE of a WITH GRANT OPTION privilege | |
| 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 | | Intervals and datetime arithmetic | |
| F053 | | OVERLAPS predicate | |
| F081 | Core | UNION and EXCEPT in views | |
| F111 | | Isolation levels other than SERIALIZABLE | |
| F112 | | Isolation level READ UNCOMMITTED | |
| F113 | | Isolation level READ COMMITTED | |
| F114 | | Isolation level REPEATABLE READ | |
| 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 | |
| F181 | Core | Multiple module support | |
| F191 | | 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 | |
| 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 | |
| F292 | | UNIQUE null treatment | |
| F302 | | INTERSECT table operator | |
| F303 | | INTERSECT DISTINCT table operator | |
| F304 | | EXCEPT ALL table operator | |
| F305 | | INTERSECT ALL table operator | |
| F311 | Core | Schema definition statement | |
| 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 | |
| F312 | | MERGE statement | |
| F313 | | Enhanced MERGE statement | |
| F314 | | MERGE statement with DELETE branch | |
| F321 | | User authorization | |
| F341 | | Usage tables | |
| F361 | | Subprogram support | |
| F381 | | Extended schema manipulation | |
| F382 | | Alter column data type | |
| F383 | | Set column not null clause | |
| F384 | | Drop identity property clause | |
| F385 | | Drop column generation expression clause | |
| F386 | | Set identity column generation clause | |
| F387 | | ALTER TABLE statement: ALTER COLUMN clause | |
| F388 | | ALTER TABLE statement: ADD/DROP CONSTRAINT clause | |
| F391 | | Long identifiers | |
| F392 | | Unicode escapes in identifiers | |
| F393 | | Unicode escapes in literals | |
| F394 | | Optional normal form specification | |
| F401 | | Extended joined table | |
| F402 | | Named column joins for LOBs, arrays, and multisets | |
| F404 | | Range variable for common column names | |
| F405 | | NATURAL JOIN | |
| F406 | | FULL OUTER JOIN | |
| F407 | | CROSS JOIN | |
| F411 | | Time zone specification | differences regarding literal interpretation |
| F421 | | National character | |
| F431 | | Read-only scrollable cursors | |
| F432 | | FETCH with explicit NEXT | |
| F433 | | FETCH FIRST | |
| F434 | | FETCH LAST | |
| F435 | | FETCH PRIOR | |
| F436 | | FETCH ABSOLUTE | |
| F437 | | FETCH RELATIVE | |
| F438 | | Scrollable cursors | |
| F441 | | Extended set function support | |
| F442 | | Mixed column references in set functions | |
| F471 | Core | Scalar subquery values | |
| F481 | Core | Expanded NULL predicate | |
| F491 | | Constraint management | |
| F501 | Core | Features and conformance views | |
| F501-01 | Core | SQL_FEATURES view | |
| F501-02 | Core | SQL_SIZING view | |
| F502 | | Enhanced documentation tables | |
| F531 | | Temporary tables | |
| F555 | | 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 | |
| F692 | | Extended collation support | |
| F701 | | 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 in query expression | |
| F851 | | ORDER BY in subqueries | |
| F852 | | Top-level ORDER BY in views | |
| F855 | | Nested ORDER BY in query expression | |
| F856 | | Nested FETCH FIRST in query expression | |
| F857 | | Top-level FETCH FIRST in query expression | |
| F858 | | FETCH FIRST in subqueries | |
| F859 | | Top-level FETCH FIRST in views | |
| F860 | | Dynamic FETCH FIRST row count | |
| F861 | | Top-level OFFSET in query expression | |
| F862 | | OFFSET in subqueries | |
| F863 | | Nested OFFSET in query expression | |
| F864 | | Top-level OFFSET in views | |
| F865 | | Dynamic offset row count in OFFSET | |
| F867 | | FETCH FIRST clause: WITH TIES option | |
| F868 | | ORDER BY in grouped table | |
| F869 | | SQL implementation info population | |
| S071 | | SQL paths in function and type name resolution | |
| S090 | | Minimal array support | |
| S092 | | Arrays of user-defined types | |
| S095 | | Array constructors by query | |
| S096 | | Optional array bounds | |
| S098 | | ARRAY_AGG | |
| S099 | | Array expressions | |
| S111 | | ONLY in query expressions | |
| S201 | | SQL-invoked routines on arrays | |
| S203 | | Array parameters | |
| S204 | | Array as result type of functions | |
| S211 | | User-defined cast functions | |
| S301 | | Enhanced UNNEST | |
| S404 | | TRIM_ARRAY | |
| T031 | | BOOLEAN data type | |
| T054 | | GREATEST and LEAST | different null handling |
| T055 | | String padding functions | |
| T056 | | Multi-character TRIM functions | |
| T061 | | UCS support | |
| T071 | | BIGINT data type | |
| T081 | | Optional string types maximum length | |
| T121 | | WITH (excluding RECURSIVE) in query expression | |
| T122 | | WITH (excluding RECURSIVE) in subquery | |
| T131 | | Recursive query | |
| T132 | | Recursive query in subquery | |
| T133 | | Enhanced cycle mark values | |
| 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 | | Referential action RESTRICT | |
| T201 | | Comparable data types for referential constraints | |
| T212 | | Enhanced trigger capability | |
| T213 | | INSTEAD OF triggers | |
| T214 | | BEFORE triggers | |
| T215 | | AFTER triggers | |
| T216 | | Ability to require true search condition before trigger is invoked | |
| T217 | | TRIGGER privilege | |
| 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-05 | Core | RETURN 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 | |
| T332 | | Extended roles | |
| T341 | | Overloading of SQL-invoked functions and SQL-invoked procedures | |
| T351 | | Bracketed comments | |
| T431 | | Extended grouping capabilities | |
| T432 | | Nested and concatenated GROUPING SETS | |
| T433 | | Multi-argument GROUPING function | |
| T434 | | GROUP BY DISTINCT | |
| 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 | | Elementary OLAP operations | |
| T612 | | Advanced OLAP operations | |
| T613 | | Sampling | |
| T614 | | NTILE function | |
| T615 | | LEAD and LAG functions | |
| T617 | | FIRST_VALUE and LAST_VALUE functions | |
| T620 | | WINDOW clause: GROUPS option | |
| T621 | | Enhanced numeric functions | |
| T622 | | Trigonometric functions | |
| T623 | | General logarithm functions | |
| T624 | | Common logarithm functions | |
| T626 | | ANY_VALUE | |
| T627 | | Window framed COUNT DISTINCT | |
| T631 | Core | IN predicate with one list element | |
| T651 | | SQL-schema statements in SQL routines | |
| T653 | | SQL-schema statements in external routines | |
| T655 | | Cyclically dependent routines | |
| T661 | | Non-decimal integer literals | |
| T662 | | Underscores in numeric literals | |
| T670 | | Schema and data statement mixing | |
| T803 | | String-based JSON | |
| T811 | | Basic SQL/JSON constructor functions | |
| T812 | | SQL/JSON: JSON_OBJECTAGG | |
| T813 | | SQL/JSON: JSON_ARRAYAGG with ORDER BY | |
| T814 | | Colon in JSON_OBJECT or JSON_OBJECTAGG | |
| T821 | | Basic SQL/JSON query operators | |
| T822 | | SQL/JSON: IS JSON WITH UNIQUE KEYS predicate | |
| T823 | | SQL/JSON: PASSING clause | |
| T825 | | SQL/JSON: ON EMPTY and ON ERROR clauses | |
| T826 | | General value expression in ON ERROR or ON EMPTY clauses | |
| T827 | | JSON_TABLE: sibling NESTED COLUMNS clauses | |
| T828 | | JSON_QUERY | |
| T829 | | JSON_QUERY: array wrapper options | |
| T830 | | Enforcing unique keys in SQL/JSON constructor functions | |
| T831 | | SQL/JSON path language: strict mode | |
| T832 | | SQL/JSON path language: item method | |
| 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 | |
| T840 | | Hex integer literals in SQL/JSON path language | |
| T851 | | SQL/JSON: optional keywords for default syntax | |
| T865 | | SQL/JSON item method: bigint() | |
| T866 | | SQL/JSON item method: boolean() | |
| T867 | | SQL/JSON item method: date() | |
| T868 | | SQL/JSON item method: decimal() | |
| T869 | | SQL/JSON item method: decimal() with precision and scale | |
| T870 | | SQL/JSON item method: integer() | |
| T871 | | SQL/JSON item method: number() | |
| T872 | | SQL/JSON item method: string() | |
| T873 | | SQL/JSON item method: time() | |
| T874 | | SQL/JSON item method: time_tz() | |
| T875 | | SQL/JSON item method: time precision | |
| T876 | | SQL/JSON item method: timestamp() | |
| T877 | | SQL/JSON item method: timestamp_tz() | |
| T878 | | SQL/JSON item method: timestamp precision | |
| T879 | | JSON in equality operations | with jsonb |
| T880 | | JSON in grouping operations | with jsonb |
| 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 | |
| X038 | | XMLText | supported except for RETURNING |
| X040 | | Basic table mapping | |
| X041 | | Basic table mapping: null 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: null 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 | |
| X069 | | XMLSerialize: INDENT | |
| 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 | |
