Re: SQL:2023 JSON simplified accessor support

Alexandra Wang <alexandra.wang.oss@gmail.com>

From: Alexandra Wang <alexandra.wang.oss@gmail.com>

To: Chao Li <li.evan.chao@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Nikita Glukhov <glukhov.n.a@gmail.com>, jian he <jian.universality@gmail.com>, Nikita Malakhov <hukutoc@gmail.com>, Vik Fearing <vik@postgresfriends.org>, Mark Dilger <mark.dilger@enterprisedb.com>, Matheus Alcantara <matheusssilv97@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, Andrew Dunstan <andrew@dunslane.net>, "David E. Wheeler" <david@justatheory.com>

Date: 2025-09-22T17:31:47Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add test coverage for indirection transformation
- 64492917280a 19 (unreleased) landed
Fix typo in comment
- 81a61fde84ff 19 (unreleased) landed
Implementation of subscripting for jsonb
- 676887a3b0b8 14.0 cited

Attachments

v21-0004-Extract-coerce_jsonpath_subscript.patch (application/octet-stream) patch v21-0004
v21-0005-Implement-read-only-dot-notation-for-jsonb.patch (application/octet-stream) patch v21-0005
v21-0001-Add-test-coverage-for-indirection-transformation.patch (application/octet-stream) patch v21-0001
v21-0002-Add-an-alternative-transform-function-in-Subscri.patch (application/octet-stream) patch v21-0002
v21-0003-Export-jsonPathFromParseResult.patch (application/octet-stream) patch v21-0003

On Sun, Sep 21, 2025 at 8:32 PM Chao Li <li.evan.chao@gmail.com> wrote:

> Looks like patch files need rebase.
>

There were trailing whitespaces in the documentation I added, I’ve fixed
them now.