Re: State of the support for the hstore ? operator

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 ??

Thomas