Re: empty string causes planner to avoid index. Makes me sad.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: empty string causes planner to avoid index. Makes me sad.
Дата
Msg-id 20827.1259359226@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: empty string causes planner to avoid index. Makes me sad.  (Jeff Amiel <becauseimjeff@yahoo.com>)
Ответы Re: empty string causes planner to avoid index. Makes me sad.
Список pgsql-general
Jeff Amiel <becauseimjeff@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

В списке pgsql-general по дате отправления:

Предыдущее
От: Pete Erickson
Дата:
Сообщение: Cannot allocate memory for output buffer
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cannot allocate memory for output buffer