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
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 |