Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN. - Mailing list pgsql-bugs

From Pelle Johansson
Subject Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.
Date
Msg-id CB4E41BE-E528-40C8-BE32-CD3922CCA0EF@morth.org
Whole thread Raw
In response to Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
16 feb 2007 kl. 22.00 skrev Tom Lane:

> "Pelle Johansson" <morth@morth.org> writes:
>> We have a join where we select which row to join on a subquery with a
>> coalesce on a column from a left join, which is not working as
>> expected.
>
> The attached patch should fix this.

Hi Tom,

Thanks for the quick fix. We don't really have any good way to apply
the patch, so we'll just use our workaround in the mean time, but
it's good to know the issue is resolved.
--
Pelle Johansson

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #3056: strange behave of CHECK constraint
Next
From: "Dr. Axel Reimann"
Date:
Subject: BUG #3030: Unable to query SQL_WCHAR column via ODBC