Re: inner join removal

Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Jul 8, 2010 at 3:05 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Right, but look for example at the logic involved with the current outer
>> join transformation identity #3, which can't be applied unless the join
>> predicate is strict for the left-hand side. �We avoid doing the dogwork
>> to test that more than once.

> Uh... where exactly is that logic?  I've been looking for it for 2
> years and haven't found it yet.

Look at the code that deals with SpecialJoinInfo.lhs_strict.  There
isn't very much of it (which is precisely my point ...)
        regards, tom lane