Re: SQL/JSON revisited

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Amit Langote <amitlangote09(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, e(dot)indrupskaya(at)postgrespro(dot)ru
Subject: Re: SQL/JSON revisited
Date: 2023-03-17 01:14:35
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 2023-03-15 We 08:49, Amit Langote wrote:
> Hi,
> On Thu, Mar 9, 2023 at 10:08 PM Peter Eisentraut
> <peter(dot)eisentraut(at)enterprisedb(dot)com> wrote:
>> On 08.03.23 22:40, Andrew Dunstan wrote:
>>> These both seem like things not worth holding up progress for, and I
>>> think it would be good to get these patches committed as soon as
>>> possible. My intention is to commit them (after some grammar
>>> adjustments) plus their documentation in the next few days.
>> If possible, the documentation for each incremental part should be part
>> of that patch, not a separate all-in-one patch.
> Here's a version that includes documentation of the individual bits in
> their own commits. I've also merged the patch to add the PLAN clause
> to JSON_TABLE into the patch that adds JSON_TABLE itself.

Hi, I have taken these and done some surgery to reduce the explosion on
grammar symbols. The attached set is just Amit's patches with some of
this surgery done - nothing other than gram.y has been touched. Patches
2 and 5 in the series could be sanely squashed onto patches 1 and 4
respectively. I haven't done anything significant yet with the JSONTABLE
patch, there is probably some more low hanging fruit there, and possibly
some still in the earlier patches.



Andrew Dunstan

Attachment Content-Type Size
v10-0001-SQL-JSON-constructors.patch text/x-patch 173.9 KB
v10-0002-reduce-number-of-new-grammar-non-terminal-symbols.patch text/x-patch 7.2 KB
v10-0003-IS-JSON-predicate.patch text/x-patch 45.5 KB
v10-0004-SQL-JSON-query-functions.patch text/x-patch 204.4 KB
v10-0005-remove-more-non-terminal-grammar-symbols.patch text/x-patch 7.0 KB
v10-0006-SQL-JSON-functions.patch text/x-patch 55.2 KB
v10-0007-RETURNING-clause-for-JSON-and-JSON_SCALAR.patch text/x-patch 12.1 KB
v10-0008-JSON_TABLE.patch text/x-patch 155.6 KB
v10-0009-Claim-SQL-standard-compliance-for-SQL-JSON-features.patch text/x-patch 2.9 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2023-03-17 01:22:42 Re: Amcheck verification of GiST and GIN
Previous Message Peter Smith 2023-03-17 01:12:15 Re: Allow logical replication to copy tables in binary format