v1-0010-Claim-SQL-standard-compliance-for-SQL-JSON-featur.patch
application/octet-stream
Filename: v1-0010-Claim-SQL-standard-compliance-for-SQL-JSON-featur.patch
Type: application/octet-stream
Part: 1
Message:
SQL/JSON revisited
Patch
Format: format-patch
Series: patch v1-0010
Subject: Claim SQL standard compliance for SQL/JSON features
| File | + | − |
|---|---|---|
| src/backend/catalog/sql_features.txt | 15 | 15 |
From 0f26f6fc9b9b3a1bf7d8043e3451aca26df95656 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan <andrew@dunslane.net> Date: Fri, 29 Apr 2022 09:01:05 -0400 Subject: [PATCH v1 10/10] Claim SQL standard compliance for SQL/JSON features Discussion: https://postgr.es/m/d03d809c-d0fb-fd6a-1476-d6dc18ec940e@dunslane.net --- src/backend/catalog/sql_features.txt | 30 ++++++++++++++-------------- 1 file changed, 15 insertions(+), 15 deletions(-) diff --git a/src/backend/catalog/sql_features.txt b/src/backend/catalog/sql_features.txt index abad216b7e..19d6fa14c7 100644 --- a/src/backend/catalog/sql_features.txt +++ b/src/backend/catalog/sql_features.txt @@ -528,20 +528,20 @@ T653 SQL-schema statements in external routines YES T654 SQL-dynamic statements in external routines NO T655 Cyclically dependent routines YES T661 Non-decimal integer literals YES SQL:202x draft -T811 Basic SQL/JSON constructor functions NO -T812 SQL/JSON: JSON_OBJECTAGG NO -T813 SQL/JSON: JSON_ARRAYAGG with ORDER BY NO -T814 Colon in JSON_OBJECT or JSON_OBJECTAGG NO -T821 Basic SQL/JSON query operators NO -T822 SQL/JSON: IS JSON WITH UNIQUE KEYS predicate NO -T823 SQL/JSON: PASSING clause NO -T824 JSON_TABLE: specific PLAN clause NO -T825 SQL/JSON: ON EMPTY and ON ERROR clauses NO -T826 General value expression in ON ERROR or ON EMPTY clauses NO -T827 JSON_TABLE: sibling NESTED COLUMNS clauses NO -T828 JSON_QUERY NO -T829 JSON_QUERY: array wrapper options NO -T830 Enforcing unique keys in SQL/JSON constructor functions NO +T811 Basic SQL/JSON constructor functions YES +T812 SQL/JSON: JSON_OBJECTAGG YES +T813 SQL/JSON: JSON_ARRAYAGG with ORDER BY YES +T814 Colon in JSON_OBJECT or JSON_OBJECTAGG YES +T821 Basic SQL/JSON query operators YES +T822 SQL/JSON: IS JSON WITH UNIQUE KEYS predicate YES +T823 SQL/JSON: PASSING clause YES +T824 JSON_TABLE: specific PLAN clause YES +T825 SQL/JSON: ON EMPTY and ON ERROR clauses YES +T826 General value expression in ON ERROR or ON EMPTY clauses YES +T827 JSON_TABLE: sibling NESTED COLUMNS clauses YES +T828 JSON_QUERY YES +T829 JSON_QUERY: array wrapper options YES +T830 Enforcing unique keys in SQL/JSON constructor functions YES T831 SQL/JSON path language: strict mode YES T832 SQL/JSON path language: item method YES T833 SQL/JSON path language: multiple subscripts YES @@ -549,7 +549,7 @@ T834 SQL/JSON path language: wildcard member accessor YES T835 SQL/JSON path language: filter expressions YES T836 SQL/JSON path language: starts with predicate YES T837 SQL/JSON path language: regex_like predicate YES -T838 JSON_TABLE: PLAN DEFAULT clause NO +T838 JSON_TABLE: PLAN DEFAULT clause YES T839 Formatted cast of datetimes to/from character strings NO M001 Datalinks NO M002 Datalinks via SQL/CLI NO -- 2.35.3