>
> 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 i
On 6 December 2014 at 00:45, Merlin Moncure 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.
--
Simon Riggs
On Fri, Dec 5, 2014 at 12:46 AM, Simon Riggs wrote:
> On 30 September 2014 at 05:53, Simon Riggs wrote:
>> On 29 September 2014 16:00, Merlin Moncure wrote:
>>> On Fri, Sep 26, 2014 at 3:06 AM, Simon Riggs wrote:
The problem, as I see it, is different. We assume that if there are
100
