Re: SQL:2023 JSON simplified accessor support

From: Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com>
To: Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: Peter Eisentraut <peter(at)eisentraut(dot)org>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Nikita Glukhov <glukhov(dot)n(dot)a(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Nikita Malakhov <hukutoc(at)gmail(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, Matheus Alcantara <matheusssilv97(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Subject: Re: SQL:2023 JSON simplified accessor support
Date: 2026-01-14 19:08:30
Message-ID: CAK98qZ2CuiORP9WDW6bbUnPNfkO+BktRSkpUucv+KAdJgJAz8A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Kirill,

On Wed, Jan 14, 2026 at 5:04 AM Kirill Reshke <reshkekirill(at)gmail(dot)com>
wrote:
> On Wed, 14 Jan 2026 at 12:59, Alexandra Wang
> <alexandra(dot)wang(dot)oss(at)gmail(dot)com> wrote:
> >
> > Hi Peter,
> >
> > Thanks for the review!
> >
> > I've attached v23.
> >
> > 0001: Implement read-only dot notation for hstore.
> > 0002: a small refactor that can be squashed with 0003.
> > 0003: Implement read-only dot notation for jsonb.
>
>
> Hi!
>
> In 0002
> > + * jsonPathFromParseResult() does second pass turning AST into binary
> * representation of jsonpath.
> */
>
> Is it "does a second pass" and "into a binary representation" ?

Thanks for the review! I’ve attached v24, which addresses your
feedback by updating the comments in 0002. 0001 and 0003 remain
unchanged from v23.

--
Alexandra Wang
EDB: https://www.enterprisedb.com

Attachment Content-Type Size
v24-0001-hstore-add-read-only-dot-notation-for-key-access.patch application/octet-stream 23.7 KB
v24-0002-Export-jsonPathFromParseResult.patch application/octet-stream 2.9 KB
v24-0003-Implement-read-only-dot-notation-for-jsonb.patch application/octet-stream 82.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2026-01-14 19:11:15 Re: how to gate experimental features (SQL/PGQ)
Previous Message Masahiko Sawada 2026-01-14 18:56:18 Re: Refactor replication origin state reset helpers