Re: SQL:2023 JSON simplified accessor support

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com>, Kirill Reshke <reshkekirill(at)gmail(dot)com>
Cc: 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-03-31 14:45:52
Message-ID: 254e3055-821e-4bd1-9b79-707f53ad0ee6@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 14.01.26 20:08, Alexandra Wang wrote:
> Hi Kirill,
>
> On Wed, Jan 14, 2026 at 5:04 AM Kirill Reshke <reshkekirill(at)gmail(dot)com
> <mailto: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 <mailto: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.

Given the ongoing discussion about json array subscripting semantics
[0], which I think is a prerequisite for this, I'm putting this patch
set on hold as Returned with feedback in the commitfest. It can be
reopened when work is ready to continue.

[0]:
https://www.postgresql.org/message-id/flat/CAK98qZ1P_edO9hZJVMuUpnXjN-9H=dz2zUj-06G5qW9CMjLqzA(at)mail(dot)gmail(dot)com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2026-03-31 14:47:37 Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
Previous Message Peter Eisentraut 2026-03-31 14:43:00 Re: jsonb subscripting vs SQL/JSON array accessor semantics (SQL:2023)