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

"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