Re: Indexing null dates - Mailing list pgsql-general

From Tom Lane
Subject Re: Indexing null dates
Date
Msg-id 3612.1082433593@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexing null dates  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Indexing null dates
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> +    <literal>NULL</> values are not indexed by default.

This is quite incorrect.  The nulls *are* indexed (at least in btree
indexes); the issue is whether there is any way to use the index to
search for them.  I do not think it helps anyone for the documentation
to get this basic point wrong, even if the distinction is subtle.

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Indexing null dates
Next
From: Joe Conway
Date:
Subject: Re: [OT] Tom's/Marc's spam filters?