Re: Partial Indexes condtions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <demolish(at)cwgsy(dot)net>
Cc: "[BUGS]" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Partial Indexes condtions
Date: 2003-08-13 14:15:30
Message-ID: 23634.1060784130@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Donald Fraser" <demolish(at)cwgsy(dot)net> writes:
> Not sure whether you classify this as a bug or not?

It's a bug --- it's fixed for 7.4. 7.3 has some problems with the
timing of constant simplification in queries vs. predicate expressions.

I'm surprised you can get it to use the index at all, though, since the
system is going to think a condition involving <> is quite unselective.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-08-13 19:27:30 Re: 7.4 beta 1: SET log_statement=false
Previous Message Tom Lane 2003-08-13 13:53:03 Re: Slow Query