Re: SQL-2016 in docs
Peter Eisentraut <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Organization | 2ndQuadrant |
| Message-ID | <[email protected]> |
On 2019-05-12 10:14, Oleg Bartunov wrote: > I noticed that in our docs for PG12 there is no SQL-2016, but we actually > have JSON Path implementation committed, which is a part of SQL-2016 > standard. One missing feature - is datetime support. Peter, will you > add this or I prepare the patch ? I did a rough check of the SQL:2016 JSON path specification versus our regression tests, and came up with the attached supported feature list. Would you like to confirm it? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
0001-Update-SQL-conformance-information-about-JSON-path.patch
(text/plain, 1.7 KB)
From fba85c745f4e84da369c623b518fcbf0718998f0 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut <[email protected]> Date: Mon, 27 May 2019 12:05:18 +0200 Subject: [PATCH] Update SQL conformance information about JSON path --- src/backend/catalog/sql_features.txt | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/src/backend/catalog/sql_features.txt b/src/backend/catalog/sql_features.txt index 68da18b3bc..ae874f38ee 100644 --- a/src/backend/catalog/sql_features.txt +++ b/src/backend/catalog/sql_features.txt @@ -543,13 +543,13 @@ 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 -T831 SQL/JSON path language: strict mode NO -T832 SQL/JSON path language: item method NO -T833 SQL/JSON path language: multiple subscripts NO -T834 SQL/JSON path language: wildcard member accessor NO -T835 SQL/JSON path language: filter expressions NO -T836 SQL/JSON path language: starts with predicate NO -T837 SQL/JSON path language: regex_like predicate NO +T831 SQL/JSON path language: strict mode YES +T832 SQL/JSON path language: item method NO datetime() not yet implemented +T833 SQL/JSON path language: multiple subscripts YES +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 T839 Formatted cast of datetimes to/from character strings NO M001 Datalinks NO -- 2.21.0