Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored - Mailing list pgsql-bugs

From David E. Wheeler
Subject Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Date
Msg-id 9CDD0519-0ABD-4E2F-AE2D-7B03B7A60738@justatheory.com
Whole thread Raw
In response to Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
List pgsql-bugs
Tree view 
On Nov 24, 2022, at 12:44, David G. Johnston <david.g.johnston@gmail.com> wrote:

> JSONPath can do/represent much more than you are thinking here.
>
> https://www.postgresql.org/docs/current/datatype-json.html#DATATYPE-JSONPATH
>
> Note the second entry ($varname) in table 8.24

Ah, I see. SQL/JSON syntax gets a bit confusing relative to other flavors.

D
Attachment

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Next
From: "David E. Wheeler"
Date:
Subject: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored