Re: Null values in indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Null values in indexes
Date
Msg-id 24462.1022692897@sss.pgh.pa.us
Whole thread Raw
In response to Re: Null values in indexes  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Null values in indexes  (Oleg Bartunov <oleg@sai.msu.su>)
List 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 by date:

Previous
From: Paul Ramsey
Date:
Subject: Re: Null values in indexes
Next
From: Ola Sundell
Date:
Subject: ipv6