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