[EMAIL PROTECTED] writes:
> select
> *
> from
> test1 left join test2 on (test1.test1_id = test2.test1_id)
> where
> test1.test1_id = test2.test1_id;
Hm. I think what is happening is that the planner is (mistakenly)
deciding that the where-clause and on-clause are equivalent, and
so dropping the second one ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
