"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> "ai" <listar(at)mail(dot)ru> wrote:
>> Oops.. I just saw, that I send you "correct" (already with
> "workaround")
>> sql-code instead of "wrong"...
>> here is "wrong" (difference is in "SELECT sub3.key3, sub4.value2
> FROM" ):
> OK, that is still happening, and looks wrong to me.
Yeah, I see it too. It seems to be evaluating the placeholder for the
COALESCE expression at the wrong join level. Not sure why, yet.
regards, tom lane