Home > mailing lists

Re: JSONPath operator and escaping values in query - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: JSONPath operator and escaping values in query
Date	July 5 04:11:47
Msg-id	CAKFQuwate+AcOjqjSPhE7W-DAdb6X+mnZVB21rZbVyotLkb1OQ@mail.gmail.com Whole thread Raw
In response to	JSONPath operator and escaping values in query (Vasu Nagendra <vasu@termtegrity.com>)
List	pgsql-general

On Thu, Jul 4, 2024 at 1:57 PM Vasu Nagendra <vasu@termtegrity.com> wrote:

SELECT '{"n": {"a-b": 1, "@ab": 2, "ab": 3}}'::jsonb @? '$ ? (@.n.a\-b >= 3)';

Which is better written as:

select '{"n": {"a-b": 1, "@ab": 2, "ab": 3}}'::jsonb @? '$ ? (@.n."a-b" >= 3)';

Using the same double-quotes you defined the key with originally.

The relevant documentation for jsonpath syntax is here:

David J.

From: Murthy Nunna
Date: 05 July, 02:56:03
Subject: psql help

From: "David G. Johnston"
Date: 05 July, 04:16:32
Subject: Re: psql help