Re: BUG #4413: LEFT JOIN not working as expected

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Jaquay" <djaquay(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4413: LEFT JOIN not working as expected
Date: 2008-09-09 21:21:00
Message-ID: 25764.1220995260@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David Jaquay" <djaquay(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2008-09-10 10:01:50 Re: issue with postgres/xml
Previous Message Jaime Casanova 2008-09-09 21:08:05 Re: BUG #4413: LEFT JOIN not working as expected