Re: SQL:2023 JSON simplified accessor support

From: Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Nikita Glukhov <glukhov(dot)n(dot)a(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "David E(dot) Wheeler" <david(at)justatheory(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>
Subject: Re: SQL:2023 JSON simplified accessor support
Date: 2025-02-05 13:39:15
Message-ID: CAK98qZ1za8XgOLY+2hQMPGoxVYFyh=dDkM2dZPVeJK4J6poyvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Wed, Feb 5, 2025 at 1:20 AM Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com>
wrote:

> I attached a minimized version of Nikita’s patch (v7):
>
> - The first three patches are refactoring steps that could be squashed
> if preferred.
> - The last two patches implement dot notation and wildcard access,
> respectively.
>
> Changes in this new version:
> - Removed code handling hstore, as Andrew pointed out it isn’t
> directly relevant to JSON access and should be handled separately.
> - Split tests for dot notation and wildcard access.
> - Dropped the two patches in v6 that enabled non-parenthesized column
> references (per Nikita’s suggestion, this will need its own separate
> discussion).
>

It appears that the Commitfest app selected the wrong patch. Sorry
about the confusion! I'm reposting the patches to correct this.

Attachment Content-Type Size
v7-0002-Pass-field-accessors-to-generic-subscripting.patch application/octet-stream 15.7 KB
v7-0005-Allow-processing-of-.-by-generic-subscripting.patch application/octet-stream 18.0 KB
v7-0001-Allow-transformation-only-of-a-sublist-of-subscri.patch application/octet-stream 6.3 KB
v7-0003-Export-jsonPathFromParseResult.patch application/octet-stream 2.4 KB
v7-0004-Implement-read-only-dot-notation-for-jsonb-using-.patch application/octet-stream 31.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2025-02-05 14:04:54 Failed assertion with jit enabled
Previous Message Peter Eisentraut 2025-02-05 13:37:21 Re: SQL:2011 application time