=?ISO-8859-1?Q?Bj=F8rn?= T Johansen <b...@havleik.no> writes:
> I have a query that looks like this...:
> select * from table where field is null
> And when I run explain, it tells me that it uses seq scan... Is this because
> pg thinks that seq scan is as fast as using indexes or because using index on
> "is null" queries does
> not work?
What PG version? Releases before 8.3 do not think that IS NULL is an
indexable condition.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
