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: [EMAIL PROTECTED]      web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to