Re: Null values in indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, dblasby(at)refractions(dot)net, chodgson(at)refractions(dot)net, pramsey(at)refractions(dot)net, jeff(at)refractions(dot)net
Subject: Re: Null values in indexes
Date: 2002-05-29 17:21:37
Message-ID: 24462.1022692897@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Hodgson 2002-05-29 17:22:16 Re: Null values in indexes
Previous Message Paul Ramsey 2002-05-29 17:16:06 Re: Null values in indexes