Horton

Re: SQL/JSON features for v15

Jonathan S. Katz <jkatz@postgresql.org>

View thread View on postgr.es
From: "Jonathan S. Katz" <jkatz@postgresql.org>
To: Andrew Dunstan <andrew@dunslane.net>, Nikita Glukhov <n.gluhov@postgrespro.ru>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Andres Freund <andres@anarazel.de>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Michael Paquier <michael@paquier.xyz>, John Naylor <john.naylor@enterprisedb.com>, Amit Langote <amitlangote09@gmail.com>
Date: 2022-08-26T16:36:11Z
Lists: pgsql-hackers 
On 8/24/22 8:16 PM, Andrew Dunstan wrote:
> 
> On 2022-08-24 We 20:05, Nikita Glukhov wrote:
>>
>>
>> v8 - is a highly WIP patch, which I failed to finish today.
>> Even some test cases fail now, and they simply show unfinished
>> things like casts to bytea (they can be simply removed) and missing
>> safe input functions.
>>
> 
> Thanks for your work, please keep going.

Thanks for the efforts Nikita.

With RMT hat on, I want to point out that it's nearing the end of the 
week, and if we are going to go forward with this path, we do need to 
review soon. The Beta 4 release date is set to 9/8, and if we are going 
to commit or revert, we should leave enough time to ensure that we have 
enough time to review and the patches are able to successfully get 
through the buildfarm.

Thanks,

Jonathan

Commits

  1. JSON_TABLE: Add support for NESTED paths and columns

  2. Add basic JSON_TABLE() functionality

  3. Add SQL/JSON query functions

  4. Add soft error handling to some expression nodes

  5. Adjust populate_record_field() to handle errors softly

  6. Refactor code used by jsonpath executor to fetch variables

  7. Add more SQL/JSON constructor functions

  8. SQL/JSON: support the IS JSON predicate

  9. SQL/JSON: add standard JSON constructor functions

  10. Revert SQL/JSON features

  11. Numeric error suppression in jsonpath