BUG #7715: hstore "exists" should use same index as "?" operator

From: ian(dot)dees(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7715: hstore "exists" should use same index as "?" operator
Date: 2012-11-30 05:02:14
Message-ID: E1TeIju-0003qb-WD@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7715
Logged by: Ian Dees
Email address: ian(dot)dees(at)gmail(dot)com
PostgreSQL version: 9.1.6
Operating system: Ubuntu 11.04
Description:

Currently the hstore documentation [0] says "hstore has GiST and GIN index
support for the @>, ?, ?& and ?| operators", but the "?" character is a
special character in JDBC and JDBC always tries to replace it with a
parameter [1]. Because of the intermingling of these two issues, it's
impossible to use the index when querying an hstore row using JDBC with the
"?" operator.

[0] http://www.postgresql.org/docs/9.1/static/hstore.html
[1]
http://stackoverflow.com/questions/11940401/escaping-hstore-contains-operators-in-a-jdbc-prepared-statement

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2012-11-30 09:02:42 Re: npgssql 5gb installation
Previous Message Simon Riggs 2012-11-30 00:18:49 Re: BUG #7572: virtualxid lock held by bgwriter on promoted slaves