Jeff Amiel <becauseimj...@yahoo.com> writes: > hmm...ok...planner is not using the index effectively (as effectively as when > a non-empty value is passed in)
You didn't show us any evidence of that, either. Both of your test
cases are using the index.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
