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