Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4413: LEFT JOIN not working as expected - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4413: LEFT JOIN not working as expected
Date
Msg-id 25764.1220995260@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4413: LEFT JOIN not working as expected  ("David Jaquay" <djaquay@gmail.com>)
List pgsql-bugs
Tree view 
"David Jaquay" <djaquay@gmail.com> writes:
> I'm seeing a problem with a LEFT JOIN.  The sql below demonstrates the
> issue.

Yeah, this is a known bug:
http://archives.postgresql.org/pgsql-bugs/2008-06/msg00175.php

It's fixed in CVS but we haven't made a new release since then.
If you don't mind patching your copy it's practically a one-liner:
http://archives.postgresql.org/pgsql-committers/2008-06/msg00336.php

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: BUG #4413: LEFT JOIN not working as expected
Next
From: Peter Eisentraut
Date:
Subject: Re: issue with postgres/xml