Skip site navigation (1) Skip section navigation (2)

Re: BUG #6232: hstore operator ? no longer uses indexes

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pierre Ducroquet <p(dot)psql(at)pinaraf(dot)info>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6232: hstore operator ? no longer uses indexes
Date: 2011-09-29 03:22:48
Message-ID: 1317266569.18190.0.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On ons, 2011-09-28 at 22:42 -0400, Tom Lane wrote:
> "Pierre Ducroquet" <p(dot)psql(at)pinaraf(dot)info> writes:
> > [ the "hstore ? text" operator no longer matches an hstore GIST index ]
> 
> Hmm ... this doesn't seem to be specific to either hstore or GIST; it's
> a collation problem.  The index is marked as having no collation, which
> is reasonable since hstore is a collation-less type.  However, the ?
> OpExpr gets marked as having "default" collation because it has one
> collatable input, namely the text constant.  And then,
> match_clause_to_indexcol decides the clause doesn't match the index.
> 
> Not sure what to do about this.  Is it okay to suppose that collation
> can be ignored when matching to a collation-less index?

That sounds correct on first reading.



In response to

Responses

pgsql-bugs by date

Next:From: Greg StarkDate: 2011-09-29 04:00:45
Subject: Re: BUG #6232: hstore operator ? no longer uses indexes
Previous:From: Tom LaneDate: 2011-09-29 02:42:55
Subject: Re: BUG #6232: hstore operator ? no longer uses indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group