Vladimir Sitnikov schrieb am 01.11.2016 um 15:00:
>>This has been "broken" for a while now, you have to use ?? to get it to work.
This still doesn't work completely with a PreparedStatement.
Other hstore operators that start with an ? do not work: ?& and ?|
e.g.:
connection.prepareStatement("select * from foo where hstore_column ?& array['key']");
connection.prepareStatement("select * from foo where hstore_column ?| array['key']");
The prepareStatement() call succeeds, but when calling executeQuery() an exception is thrown:
org.postgresql.util.PSQLException: No value specified for parameter 1.
The goal is to pass the array as a parameter, something like:
Array keys = con.createArrayOf("text", new String[] {"key1","key2"});
connection.prepareStatement("select * from foo where hstore_column ?& ?");
pstmt.setArray(1, keys);
ResultSet rs = pstmt.executeQuery();
Tested with 1212 and 42.0.0
Regards
Thomas