Re: bitmap index and IS NULL predicate - Mailing list pgsql-performance

On 5/15/07, Jason Pinnix <pinnixjason@yahoo.com> wrote:
> Does the bitmap
> index not store a bit vector for the NULL value (i.e. a bit vector that
> contains a 1 for each row with a NULL value and 0 for other rows) ?

You should be able to do this with a conditional index:

  create index ... (col) where col is null;

Alexander.