Will Leinweber <w...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers