On Mon, 2005-11-14 at 11:30, Csaba Nagy wrote:
> The OP was complaining about the results of the above script, which I
> could readily reproduce on a 8.1.0 installation on debian (see below).
> The same select which returned 3 rows will return nothing after creating
> the partial indexes, which looks as a bug to me...
> I can't tell anything about why it happens, just confirm that I can
> reproduce too...
Yep, I just reproduced it too.
In the future, I'd recommend they include the bad output, as I simply
thought "unpredictable output" was referring to performance, not the
actual data.