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 Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------