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

On Nov 24, 2022, at 12:55, David E. Wheeler <david(at)justatheory(dot)com> wrote:

> Yeah, this doesn’t seem right, either:
>
> david=# select jsonb_path_exists('{"foo": {"bar": true}}', '$path', '{"path": "$.foo.bax"}');
> jsonb_path_exists
> —————————
> t

david=# select '{}' @? '$.emails.work == "hi(at)home(dot)com"';
?column?
----------
t

Works properly with `@@`, though:

david=# select '{}' @@ '$.emails.work == "hi(at)home(dot)com"';
?column?
----------
f

Have to admit I find this pretty weird. I see that the docs say that this Postgres-specific boolean predicate syntax is required for @@, but it doesn’t say it doesn’t apply to @? But the `?()` filter syntax works as expected with @?:

david=# select '{}' @? '$.emails.work ?(@ == "hi(at)home(dot)com")';
?column?
----------
f

Wondering if I should avoid `(at)?`(dot) Frankly I don’t understand the difference between `@@` and `(at)?`(dot)

Best,

David