From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: JDBC and the hstore ? operator - no longer working with build 1211 |
Date: | 2016-11-01 13:53:15 |
Message-ID: | CADK3HHJ50aqPHqGOdpeja1tHnpgju8HwKA9Yi8j_1wk0n58ifg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Sitnikov | 2016-11-01 14:00:10 | Re: JDBC and the hstore ? operator - no longer working with build 1211 |
Previous Message | Mithun Cy | 2016-11-01 13:43:35 | Re: Patch: Implement failover on libpq connect level. |