Postgres Pro
Downloads
Home   >   mailing lists

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

From Vladimir Sitnikov
Subject Re: ? In jsonpath syntax in sql-2016
Date
Msg-id CAB=Je-Et-LqfPJbBj4BfdCWU7HGyeiYU3a-nKsznchaMvkWwpA@mail.gmail.com
Whole thread Raw
In response to ? In jsonpath syntax in sql-2016  (Dave Cramer <davecramer@gmail.com>)
Responses Re: ? In jsonpath syntax in sql-2016  (Dave Cramer <davecramer@gmail.com>)
List pgsql-jdbc
Tree view
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.

PS. it seems the discussion went off-list somehow.

Vladimir

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: SCRAM inplementation
Next
From: Dave Cramer
Date:
Subject: Re: ? In jsonpath syntax in sql-2016