Re: Partial Indexes condtions - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Partial Indexes condtions
Date
Msg-id 23634.1060784130@sss.pgh.pa.us
Whole thread Raw
In response to Partial Indexes condtions  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-bugs
"Donald Fraser" <demolish@cwgsy.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow Query
Next
From: Bertrand Petit
Date:
Subject: 7.4 beta 1: SET log_statement=false