Postgres Pro
Downloads
Home   >   mailing lists

Re: ? In jsonpath syntax in sql-2016 - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: ? In jsonpath syntax in sql-2016
Date
Msg-id CADK3HHL_dE1zrL=T+TZ1bErP-fj1ZjOYMaLFkKE8FVHE=AUwMg@mail.gmail.com
Whole thread Raw
In response to Re: ? In jsonpath syntax in sql-2016  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Responses Re: ? In jsonpath syntax in sql-2016  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
List pgsql-jdbc
Tree view

On 31 March 2017 at 09:01, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:
Dave> SELECT * FROM js WHERE JSON_EXISTS(js, 'strict $.tags[*] ? (@.term == "NYC")');
Dave> http://www.sai.msu.su/~megera/postgres/talks/jsonb-pgconf.us-2017.pdf


The question mark is a part of a string literal, so it makes no harm to JDBC.

I was thinking we would have trouble parsing it, no ?

Dave Cramer

pgsql-jdbc by date:

Previous
From: Vladimir Sitnikov
Date:
Subject: Re: ? In jsonpath syntax in sql-2016
Next
From: Vladimir Sitnikov
Date:
Subject: Re: ? In jsonpath syntax in sql-2016