On Fri, Dec 5, 2014 at 12:46 AM, Simon Riggs si...@2ndquadrant.com wrote:
On 30 September 2014 at 05:53, Simon Riggs si...@2ndquadrant.com wrote:
On 29 September 2014 16:00, Merlin Moncure mmonc...@gmail.com wrote:
On Fri, Sep 26, 2014 at 3:06 AM, Simon Riggs si...@2ndquadrant.com wrote:
The
On 6 December 2014 at 00:45, Merlin Moncure mmonc...@gmail.com wrote:
Neat -- got any test cases (would this have prevented OP's problem)?
No test case was posted, so I am unable to confirm.
A test case I produced that appears to be the same issue is fixed.
I await confirmation from the OP.
Well, first off, a btree index is fairly useless for this query,
because btree has no concept that the hstore has any sub-structure.
A GIN index or GIST index could work though. Secondly, you have to
remember that indexable WHERE conditions in Postgres are *always* of
the form WHERE