Re: query planner does not canonicalize infix operators
| От | Daniel Farina |
|---|---|
| Тема | Re: query planner does not canonicalize infix operators |
| Дата | |
| Msg-id | CAAZKuFZoaC7B9H=kO-8_RPY1EejZp7vwqDdQg+mfeOb1yZmvLA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: query planner does not canonicalize infix operators (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: query planner does not canonicalize infix operators
|
| Список | pgsql-hackers |
On Mon, Mar 12, 2012 at 7:52 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > 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. Is this saying "there no need for that" or "no one is working on it, and I certainly don't intend to", or "definitely not in the next version" or something else entirely? I disagreement with the former, and am in total understanding of the latter two. -- fdr
В списке pgsql-hackers по дате отправления: