index doesn't work for null? - Mailing list pgsql-general

From Alex Pilosov
Subject index doesn't work for null?
Date
Msg-id Pine.BSO.4.10.10105151823150.26275-100000@spider.pilosoft.com
Whole thread Raw
List pgsql-general
I have a bit of a problem:

'select from xx where field=null' will always result in seq scan even when
there's a [btree] index on the field.

Is this a known issue?

-alex


pgsql-general by date:

Previous
From: Ryan Mahoney
Date:
Subject: Re: Performance aggregates
Next
From: Bill McGonigle
Date:
Subject: trouble with the automatic indexes on CREATE TABLE