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

On Nov 24, 2022, at 12:16, David G. Johnston <david.g.johnston@gmail.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
atthe start of a JSONPath, AFAICT. But when running 

    select '{"foo": 1}' @? ‘$foo'

or

    select '{}' @? ‘$foo'

(both of which incorrectly return true), there is no `$foo` path; it has to be `$.foo`.

Best,

David