Postgres Pro
Downloads
Home   >   mailing lists

Re: Index not used with IS NULL - Mailing list pgsql-general

From Greg Stark
Subject Re: Index not used with IS NULL
Date
Msg-id 878ywefjel.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Index not used with IS NULL  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Martijn van Oosterhout <kleptog@svana.org> writes:
>
> I would have thought that the other index type supported null anyway, for
> the purposes of uniqueness checks.

Well, rtree indexes are used for boxes, which don't even have a useful =
operators anyways... Unique indexes on them wouldn't work very well.

--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index not used with IS NULL
Next
From: Tom Lane
Date:
Subject: Re: foreign key constraints and alter table