short circuit joins

[Marcus Engene <mengpg2(at)engene(dot)se>]

Hi,

-- a
select
   ...
from
   base_table bt
   left outer join sub_table_1 st1 on (st1.base_table = bt.id)
   left outer join sub_table_2 st1 on (st2.base_table = bt.id)

-- b
select
   ...
from
   base_table bt
   left outer join sub_table_1 st1 on (bt.objecttype = 1 AND 
st1.base_table = bt.id)
   left outer join sub_table_2 st1 on (bt.objecttype = 2 AND 
st2.base_table = bt.id)

Pretend this is some stupid way of object orientation. base_table is the 
base class and sub_table_x are subclasses. base_table.objecttype tells 
which instance it is. Just for the sake of discussion, it could also be 
like "bt.is_married_monogamous = 1 AND wife.husband = bt.id" for example.

In case b, does Postgres avoid to unnecessarily try look for respective 
sub_table ? Is it worthwhile to have?

I'm on 8.3 presently. Still curious if newer versions have some 
optimization here.

Best regards,
Marcus