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:51, David E. Wheeler <david@justatheory.com> wrote:

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

Yeah, this doesn’t seem right, either:

david=# select jsonb_path_exists('{"foo": {"bar": true}}', '$path', '{"path": "$.foo.bax"}');
 jsonb_path_exists
-------------------
 t

D