Re: Index not used with IS NULL

Nick Wellnhofer <wellnhofer@aevum.de> writes:
> If I have a query like
> SELECT * FROM table WHERE key IS NULL
> and an index on column "key", a sequential scan is used.

IS NULL is not an indexable operator.

I suggest reconsidering your data representation, as this is unlikely to
change soon...

            regards, tom lane