Thank you! =) Best Regards, Alex
-----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Tuesday, August 09, 2011 11:53 AM To: ai Cc: Kevin Grittner; [email protected] Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins I wrote: > "Kevin Grittner" <[email protected]> writes: >> "ai" <[email protected]> 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. Found it --- the code only fails for the case where the COALESCE subexpression is referenced in the upper targetlist, but not the quals (ie, not ON or WHERE). Patch committed, thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
