Thread: ? In jsonpath syntax in sql-2016
In the jsonb talk with oleg. Apparently sql 2016 uses ?
Dave>In the jsonb talk with oleg. Apparently sql 2016 uses ?
Can you elaborate a bit?
Vladimir
Dave> SELECT * FROM js WHERE JSON_EXISTS(js, 'strict $.tags[*] ? (@.term == "NYC")');
PS. it seems the discussion went off-list somehow.
Vladimir
Vladimir
On 31 March 2017 at 09:01, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:
Dave Cramer
Dave> SELECT * FROM js WHERE JSON_EXISTS(js, 'strict $.tags[*] ? (@.term == "NYC")');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
Dave>I was thinking we would have trouble parsing it, no ?
pgjdbc ignores string literals and comments, so are fine there.
Vladimir
Vladimir