On Wed, 10 Nov 2010 10:00:43 -0500 Tom Lane <t...@sss.pgh.pa.us> wrote:
> =?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 > We are using version 8.4.x... BTJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
