Re: State of the support for the hstore ? operator

Laurenz Albe wrote:
> Thomas Kellerer wrote:
>> 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 think that is a bug in org/postgresql/core/Parser: Even if "withParameters"
> is false, it parses question marks.
> 
> I'll try to come up with a patch.

Here:
https://github.com/pgjdbc/pgjdbc/pull/427

Yours,
Laurenz Albe