My main point here is researching how difficult it is to add functionality in the planner to allow it to to detect and make decisions on foreign keys present in the outer relation.
I think that if this is added, rest of the work would be much easier. I amy be completely wrong,though. Thoughts/Comments? Regards, Atri Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers