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

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(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:55:25
Message-ID: 1DBB0108-3DB1-43BF-BA5A-DCF64743D895@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Nov 24, 2022, at 12:51, David E. Wheeler <david(at)justatheory(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2022-11-24 22:23:56 Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Previous 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