Re: ❓ JSON Path Dot Precedence - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: ❓ JSON Path Dot Precedence
Date
Msg-id 762BE227-F066-43F2-A61D-DBFB7844CE65@justatheory.com
Whole thread Raw
In response to Re: ❓ JSON Path Dot Precedence  (Peter Eisentraut <peter@eisentraut.org>)
List pgsql-hackers
On Apr 10, 2024, at 10:29, Peter Eisentraut <peter@eisentraut.org> wrote:

> So the whole thing is
>
> <JSON path literal> <period> <JSON path key name>
>
> The syntax of <JSON path literal> and <JSON path key name> is then punted to ECMAScript 5.1.
>
> 0x2 is a HexIntegerLiteral.  (There can be no dots in that.)
>
> p10 is an Identifier.
>
> So I think this is all correct.

That makes sense, thanks. It’s just a little odd to me that the resulting path isn’t a query at all. To Erik’s point:
whatpath can `'0x2.p10` even select? 

Best,

David




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Issue with the PRNG used by Postgres
Next
From: Melanie Plageman
Date:
Subject: Re: Table AM Interface Enhancements