---
title: "Supported Features"
id: features-sql-standard
pg_version: "20devel"
---

<a id="features-sql-standard"></a>

## D.1. Supported Features

| Identifier | Core? | Description | Comment | 
| --- | --- | --- | --- |
| 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 |  | 
| F492 |  | Optional table constraint enforcement | except not-null constraints | 
| 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 |  | 
| G000 |  | Graph pattern | SQL/PGQ required | 
| G001 |  | Repeatable-elements match mode | SQL/PGQ required | 
| G008 |  | Graph pattern WHERE clause | SQL/PGQ required | 
| G034 |  | Path concatenation | SQL/PGQ required | 
| G040 |  | Vertex pattern | SQL/PGQ required | 
| G042 |  | Basic full edge patterns | SQL/PGQ required | 
| G044 |  | Basic abbreviated edge patterns |  | 
| G070 |  | Label expression: label disjunction | SQL/PGQ required | 
| G073 |  | Label expression: individual label name | SQL/PGQ required | 
| G090 |  | Property reference | SQL/PGQ required | 
| G850 |  | SQL/PGQ Information Schema views |  | 
| G900 |  | GRAPH_TABLE | SQL/PGQ required | 
| G920 |  | DDL-based SQL-property graphs | SQL/PGQ required | 
| G921 |  | Empty SQL-property graph |  | 
| G922 |  | Views as element tables |  | 
| G924 |  | Explicit key clause for element tables | SQL/PGQ required | 
| G925 |  | Explicit label and properties clause for element tables | SQL/PGQ required | 
| G926 |  | More than one label for vertex tables |  | 
| G927 |  | More than one label for edge tables |  | 
| G928 |  | Value expressions as properties and renaming of properties |  | 
| G940 |  | Multi-sourced/destined edges |  | 
| G941 |  | Implicit removal of incomplete edges |  | 
| G950 |  | Alter property graph statement: ADD/DROP element table |  | 
| G960 |  | Alter element table definition: ADD/DROP LABEL |  | 
| G970 |  | Alter element table definition: ALTER LABEL |  | 
| G980 |  | DROP PROPERTY GRAPH: CASCADE drop behavior |  | 
| 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 |  | 
| T616 |  | Null treatment option for 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 |  | 
| T824 |  | JSON_TABLE: specific PLAN 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 |  | 
| T838 |  | JSON_TABLE: PLAN DEFAULT clause |  | 
| 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 |  |