Re: State of the support for the hstore ? operator

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: State of the support for the hstore ? operator
Date: 2015-11-18 10:53:54
Message-ID: n2hlc2$j4f$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Albe Laurenz 2015-11-18 13:10:14 Re: State of the support for the hstore ? operator
Previous Message Albe Laurenz 2015-11-18 10:35:23 Re: State of the support for the hstore ? operator