Re: query planner does not canonicalize infix operators - Mailing list pgsql-hackers

From Tom Lane
Subject Re: query planner does not canonicalize infix operators
Date
Msg-id 17479.1331563953@sss.pgh.pa.us
Whole thread Raw
In response to query planner does not canonicalize infix operators  (Will Leinweber <will@heroku.com>)
Responses Re: query planner does not canonicalize infix operators
List pgsql-hackers
Will Leinweber <will@heroku.com> writes:
> I created an index on an hstore function, fetchval(hstore, text), however
> when I use the -> infix operator which resolves to the very same function,
> this index is not used. It should be used.

Don't hold your breath.  Create an index on the expression you intend to
use, not random respellings of it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] Add GUC sepgsql.client_label
Next
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] Add GUC sepgsql.client_label