Re: ? In jsonpath syntax in sql-2016

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: Vladimir Sitnikov <sitnikov(dot)vladimir(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:04:16
Message-ID: CADK3HHL_dE1zrL=T+TZ1bErP-fj1ZjOYMaLFkKE8FVHE=AUwMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 31 March 2017 at 09:01, Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2017-03-31 13:20:47 Re: ? In jsonpath syntax in sql-2016
Previous Message Vladimir Sitnikov 2017-03-31 13:01:31 Re: ? In jsonpath syntax in sql-2016