Re: Index not used with IS NULL

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Dima Tkach <dmitry(at)openratings(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index not used with IS NULL
Date: 2003-02-16 18:12:45
Message-ID: 20030216100708.J94589-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sat, 15 Feb 2003, Dima Tkach wrote:

> It would be a lot nicer if the default operators could handle that...
> Why can it not be done?

Jumping in... I usually use a partial index as a workaround. Postgresql
will look at a partial index whose condition is IS NULL for queries of col
IS NULL.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-16 19:29:13 Re: In 7.3.1, will I be able to reindex toast?
Previous Message Tom Lane 2003-02-16 18:03:42 Re: Index not used with IS NULL