Jeff Amiel <becauseimjeff@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
