Re: SQL/JSON revisited

Amit Langote <amitlangote09@gmail.com>

From: Amit Langote <amitlangote09@gmail.com>

To: vignesh C <vignesh21@gmail.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, Andrew Dunstan <andrew@dunslane.net>, e.indrupskaya@postgrespro.ru

Date: 2023-01-30T06:39:12Z

Lists: pgsql-hackers

Attachments

v3-0011-Proposed-reworking-of-SQL-JSON-documentaion.patch (application/octet-stream) patch v3-0011
v3-0010-Claim-SQL-standard-compliance-for-SQL-JSON-featur.patch (application/octet-stream) patch v3-0010
v3-0009-Documentation-for-SQL-JSON-features.patch (application/octet-stream) patch v3-0009
v3-0007-JSON_TABLE.patch (application/octet-stream) patch v3-0007
v3-0008-PLAN-clauses-for-JSON_TABLE.patch (application/octet-stream) patch v3-0008
v3-0006-RETURNING-clause-for-JSON-and-JSON_SCALAR.patch (application/octet-stream) patch v3-0006
v3-0005-SQL-JSON-functions.patch (application/octet-stream) patch v3-0005
v3-0003-IS-JSON-predicate.patch (application/octet-stream) patch v3-0003
v3-0004-SQL-JSON-query-functions.patch (application/octet-stream) patch v3-0004
v3-0002-SQL-JSON-constructors.patch (application/octet-stream) patch v3-0002
v3-0001-Common-SQL-JSON-clauses.patch (application/octet-stream) patch v3-0001

On Fri, Jan 27, 2023 at 11:27 PM vignesh C <vignesh21@gmail.com> wrote:
> On Tue, 17 Jan 2023 at 19:01, Amit Langote <amitlangote09@gmail.com> wrote:
> > And I've just finished doing that.  In the attached updated 0004,
> > which adds the JsonExpr node, its evaluation code is now broken into
> > ExprEvalSteps to handle the subsidiary JsonCoercion and JsonBehavior
> > expression nodes that previously used ExprState for recursive
> > evaluation.  Andres didn't like the latter as previously discussed at
> > [1].
> >
> > I've also attached the patch that Elena has proposed as the patch
> > 0011.  I haven't managed to review it yet, though once I do, I'll
> > merge it into the main documentation patch 0009.  Thanks Elena.
>
> The patch does not apply on top of HEAD as in [1], please post a rebased patch:

Thanks for the heads up.  Here's a rebased version.

-- 
Thanks, Amit Langote
EDB: http://www.enterprisedb.com

Commits

Add SQL/JSON query functions
- 6185c9737cf4 17.0 landed
Add soft error handling to some expression nodes
- aaaf9449ec6b 17.0 landed
Adjust populate_record_field() to handle errors softly
- 1edb3b491bee 17.0 landed
Refactor code used by jsonpath executor to fetch variables
- faa2b953ba3b 17.0 landed
Code review for recent SQL/JSON commits
- 71bfd1543f8b 16.0 landed
Fix inconsistencies and style issues in new SQL/JSON code
- 60966f56c3e4 16.0 landed
Don't install postmaster symlink anymore
- 37e267335068 16.0 cited
Revert SQL/JSON features
- 2f2b18bd3f55 16.0 cited
Doc: standardize markup a bit more.
- 47046763c3ed 13.0 cited