Re: [PERFORM] bitmap index and IS NULL predicate

2007-05-15 Thread Alexander Staubo
On 5/15/07, Jason Pinnix <[EMAIL PROTECTED]> 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

[PERFORM] bitmap index and IS NULL predicate

2007-05-15 Thread Jason Pinnix
Hello, I'm running version 8.2 with the bitmap index patch posted on pgsql-hackers. While selection queries with equality predicates (col = value) are able to make use of the bitmap index, those with IS NULL predicates (col IS NULL) are not able to use the bitmap index. The online manuals seem