index doesn't work for null?

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: index doesn't work for null?
Date: 2001-05-15 22:25:31
Message-ID: Pine.BSO.4.10.10105151823150.26275-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nils Zonneveld 2001-05-15 22:26:03 Re: SELECT from a table in another database
Previous Message Bill McGonigle 2001-05-15 22:21:20 trouble with the automatic indexes on CREATE TABLE