> Well, I guess so, but I can't get excited about adding machinery to
> detect cases like this ... are there any less-silly examples that make
> a more compelling case for expending planner cycles to see if an outer
> join can be reduced to an inner join?
Well, in all cases the outer join reduces to an inner join if there is a
qualification which would eliminate nulls from any intermediate result.
It would be neat to see this happen automagically, but perhaps that
would be a gratuitously studly feature ;)
- Thomas