Re: ? In jsonpath syntax in sql-2016

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Dave Cramer <davecramer(at)gmail(dot)com>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: ? In jsonpath syntax in sql-2016
Date: 2017-03-31 13:01:31
Message-ID: CAB=Je-Et-LqfPJbBj4BfdCWU7HGyeiYU3a-nKsznchaMvkWwpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2017-03-31 13:04:16 Re: ? In jsonpath syntax in sql-2016
Previous Message Dave Cramer 2017-03-31 12:31:01 SCRAM inplementation