Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Date: 2022-11-24 17:44:21
Message-ID: CAKFQuwa4=K=xV=M7AEOczAyWSZS96X513YBo9-7gHqsvsgcqHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Nov 24, 2022 at 10:27 AM David E. Wheeler <david(at)justatheory(dot)com>
wrote:

> On Nov 24, 2022, at 12:16, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
> > There is a bug in this area though the syntax itself is valid since
> you've simply defined a variable.
>
> Sorry, I don’t follow. What variable is defined? I mean `$` is a variable
> for the whole expression, and always required at the start of a JSONPath

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

David J.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David E. Wheeler 2022-11-24 17:51:47 Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Previous Message David E. Wheeler 2022-11-24 17:26:58 Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored