Re: Null values in indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Null values in indexes
Дата
Msg-id 24462.1022692897@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Null values in indexes  ("Dann Corbit" <DCorbit@connx.com>)
Ответы Re: Null values in indexes  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-hackers
>> Urgh ... that means GiST indexing is actually broken, because GiST
>> currently handles multicolumns but not nulls.

Actually, it appears that 7.2 GiST does handle NULLs in columns after
the first one, which I think is enough to avoid the problem Jan
mentioned.  The boolean column pg_am.amindexnulls is not really
sufficient to describe this behavior accurately.  Looking at current
uses it seems correct to leave it set FALSE for GiST.

In short: false alarm; the 7.2 code is okay as-is, at least on this
particular point.
        regards, tom lane


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

Предыдущее
От: Paul Ramsey
Дата:
Сообщение: Re: Null values in indexes
Следующее
От: Ola Sundell
Дата:
Сообщение: ipv6