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

From Tom Lane
Subject Re: Null values in indexes
Date
Msg-id 17471.1022625146@sss.pgh.pa.us
Whole thread Raw
In response to Re: Null values in indexes  (Hannu Krosing <hannu@tm.ee>)
Responses Re: Null values in indexes  (Jan Wieck <janwieck@yahoo.com>)
List 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 by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Interval oddities
Next
From: Tom Lane
Date:
Subject: Re: wierd AND condition evaluation for plpgsql