for example:

select    t1.*
from      t1
left join t2 on( <expensive condition> );

since t2 is not used in the result nor is it used in determining the result, is 
the <expensive condition> to left join t2 used?

(the question goes as to how much generated sql needs to be cleaned to be 
efficient)



      

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to