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-10T23:56:40Z
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
- v18-0006-Implement-Jsonb-subscripting-with-slicing.patch (application/octet-stream) patch v18-0006
- v18-0001-Allow-transformation-of-only-a-sublist-of-subscr.patch (application/octet-stream) patch v18-0001
- v18-0004-Extract-coerce_jsonpath_subscript.patch (application/octet-stream) patch v18-0004
- v18-0007-Implement-jsonb-wildcard-member-accessor.patch (application/octet-stream) patch v18-0007
- v18-0005-Implement-read-only-dot-notation-for-jsonb.patch (application/octet-stream) patch v18-0005
- v18-0003-Export-jsonPathFromParseResult.patch (application/octet-stream) patch v18-0003
- v18-0002-Allow-Generic-Type-Subscripting-to-Accept-Dot-No.patch (application/octet-stream) patch v18-0002
Hi Chao, On Tue, Sep 9, 2025 at 9:03 PM Chao Li <li.evan.chao@gmail.com> wrote: > I don’t see you have updated any documentation yet. I don’t want to block > you because of this issue. As long as you state the behavior clearly in the > document, I am happy to let it go. > Thanks for the reminder for documentation! I've attached v18. v18 adds documentation in 0005. I've also updated the commit messages for 0003, 0004, and 0007 to include reviewers' names. For everyone: my immediate goal is to move 0001 - 0005 forward, as I feel more confident about them now. In the meantime, I'd also appreciate code review for 0006 - 0007. Best, Alex