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

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: JDBC and the hstore ? operator - no longer working withbuild 1211
Дата
Msg-id CADK3HHJ50aqPHqGOdpeja1tHnpgju8HwKA9Yi8j_1wk0n58ifg@mail.gmail.com
обсуждение исходный текст
Ответ на JDBC and the hstore ? operator - no longer working with build 1211  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: JDBC and the hstore ? operator - no longer working withbuild 1211
Список pgsql-jdbc
Thomas,

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


On 31 October 2016 at 17:07, Thomas Kellerer <spam_eater@gmx.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Re: JDBC and the hstore ? operator - no longer working with build 1211
Следующее
От: Vladimir Sitnikov
Дата:
Сообщение: Re: JDBC and the hstore ? operator - no longer working withbuild 1211