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: 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>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, "David E. Wheeler" <david@justatheory.com>

Date: 2025-09-15T18:32:52Z

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

v19-0005-Implement-read-only-dot-notation-for-jsonb.patch (application/octet-stream) patch v19-0005
v19-0006-Implement-Jsonb-subscripting-with-slicing.patch (application/octet-stream) patch v19-0006
v19-0001-Allow-transformation-of-only-a-sublist-of-subscr.patch (application/octet-stream) patch v19-0001
v19-0004-Extract-coerce_jsonpath_subscript.patch (application/octet-stream) patch v19-0004
v19-0007-Implement-jsonb-wildcard-member-accessor.patch (application/octet-stream) patch v19-0007
v19-0003-Export-jsonPathFromParseResult.patch (application/octet-stream) patch v19-0003
v19-0002-Allow-Generic-Type-Subscripting-to-Accept-Dot-No.patch (application/octet-stream) patch v19-0002

Hi,

I’ve rebased the patch set, no changes since v18.

Best,
Alex