From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'Thomas Kellerer *EXTERN*'" <spam_eater(at)gmx(dot)net>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: State of the support for the hstore ? operator |
Date: | 2015-11-18 13:10:14 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B50FE70D1@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Thomas Kellerer wrote:
> Albe Laurenz schrieb am 18.11.2015 um 11:35:
>>> I just stumbled upon this (using postgresql-9.4-1205.jdbc42.jar)
>>>
>>> Statement stmt = con.createStatement();
>>> ResultSet rs = stmt.executeQuery("select count(*) from product where attributes ? 'location_id'");
>>>
>>> results in
>>>
>>> org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
>>>
>> I looked into the source, and you can escape the question mark by doubling it.
>
> Ah, right, thanks.
>
> I knew there was something available - I tried \? and "?" but didn't think of ??
I see that it is mentioned in the documentation source (since Dec 2014, commit
31c5fcf9d620eb8403ec03682d8f90210da827f3), but I can't find it in the documentation
available on the web site.
Has the documentation on the web site been built recently?
I tried to build the documentation myself with "ant -lib lib doc", but it
failed with
java.io.FileNotFoundException: /path/to/pgjdbc/doc/${docbook.stylesheet} (No such file or directory)
Am I missing something?
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2015-11-18 13:35:42 | Re: State of the support for the hstore ? operator |
Previous Message | Thomas Kellerer | 2015-11-18 10:53:54 | Re: State of the support for the hstore ? operator |