Re: inner join removal

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Thu, Jul 8, 2010 at 3:05 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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