Re: Index not used with IS NULL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index not used with IS NULL
Дата
Msg-id 8458.1045494628@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index not used with IS NULL  (Dima Tkach <dmitry@openratings.com>)
Ответы Re: Index not used with IS NULL
Список pgsql-general
Dima Tkach <dmitry@openratings.com> writes:
> I'd be happy to come up with a patch... It just was my understanding
> that you would not accept such a patc hanyway, because your opinion is
> that it is unnecessary and dangerous... Did I misunderstand you here?

I don't see anything dangerous about it --- except perhaps to
readability and mantainability of the code.  The problem is that IS NULL
doesn't fit into the operator-and-opclass model of what indexes can do.
If you can find a solution to that problem that's not a complete kluge,
I'm all ears.

            regards, tom lane

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

Предыдущее
От: Dima Tkach
Дата:
Сообщение: Re: Index not used with IS NULL
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: HOWTO Migration