Tom-
Thanks for the detective work. This makes perfect sense now, and explains
the radically different behaviour between 7.1RC1 and 7.1.1. I will change
my rules to not have to depend on Pg choosing which WHERE clause to
evaluate first.
-Jon
PS: (Talking *way* above my head now) Would be possible to have
EXPLAIN flag this type of problem? Remember, the EXPLAIN output for
7.1RC1 and 7.1.1 were identical.
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---Jon LaphamExtracta Moléculas Naturais, Rio de
Janeiro,Brasilemail: lapham@extracta.com.br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------