Re: JDBC and the hstore ? operator - no longer working with build 1211

Thomas,

This has been "broken" for a while now, you have to use ?? to get it to
work.

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 31 October 2016 at 17:07, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> The support for using the hstore ? operator without a PreparedStatement
> worked with build 1208, but is broken (again) with build 1211
>
> The following works with build 1208
>
> Connection conn = DriverManager.getConnection(...);
> Statement stmt = conn.createStatement();
> ResultSet rs = stmt.executeQuery("select * from some_table where
> hstore_column ? 'foo');
>
> with build 1211 it throws an exception with the message:
>
> org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
>
> Was this intended to work in build 1208 or was that just by accident?
>
> Thomas
>
>
>
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>