On Mon, 2005-10-31 at 15:30 -0500, Tom Lane wrote:
> mark(at)mark(dot)mielke(dot)cc writes:
> > I've been trying to figure out whether null values are indexed or not from
> > the documentation. I was under the impression, that null values are not
> > stored in the index.
>
> You're mistaken, at least with regard to btree indexes.
Ha! So I'm creating an index 98% full of nulls! Looks like this is
easily fixed with partial indexes.
-K