Postgres Pro
Downloads
Home   >   mailing lists

Re: LEFT OUTER JOIN and WHERE madness (8.3.3 bug?) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: LEFT OUTER JOIN and WHERE madness (8.3.3 bug?)
Date
Msg-id 11493.1214600915@sss.pgh.pa.us
Whole thread Raw
In response to LEFT OUTER JOIN and WHERE madness (8.3.3 bug?)  (toruvinn <toruvinn@lain.pl>)
List pgsql-bugs
Tree view 
toruvinn <toruvinn@lain.pl> writes:
> The thing is, for some reason 8.3.3 doesn't correctly (left outer) join
> the tables when an additional condition in WHERE clause is supplied.

The patch for this is practically a one-liner, if you need it right
away:

http://archives.postgresql.org/pgsql-committers/2008-06/msg00336.php

            regards, tom lane

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #4267: initdb fails
Next
From: "Dave Page"
Date:
Subject: Re: BUG #4267: initdb fails