Re: Null values in indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Null values in indexes
Дата
Msg-id 17471.1022625146@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Null values in indexes  (Hannu Krosing <hannu@tm.ee>)
Ответы Re: Null values in indexes  (Jan Wieck <janwieck@yahoo.com>)
Список pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> How hard would it be to _not_ include nulls in indexes 
> as they are not used anyway. 

Seems to me that would be a step backwards.

What should someday happen is to make IS NULL an indexable operator.
The fact that we haven't got around to doing so is not a reason to
rip out the underpinnings for it.
        regards, tom lane


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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: Interval oddities
Следующее
От: Tom Lane
Дата:
Сообщение: Re: wierd AND condition evaluation for plpgsql