Skip site navigation (1) Skip section navigation (2)

Re: LEFT OUTER JOIN and WHERE madness (8.3.3 bug?)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: toruvinn <toruvinn(at)lain(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: LEFT OUTER JOIN and WHERE madness (8.3.3 bug?)
Date: 2008-06-27 21:08:35
Message-ID: 11493.1214600915@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
toruvinn <toruvinn(at)lain(dot)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

In response to

pgsql-bugs by date

Next:From: Dave PageDate: 2008-06-28 12:56:00
Subject: Re: BUG #4267: initdb fails
Previous:From: Craig RingerDate: 2008-06-27 17:26:35
Subject: Re: BUG #4267: initdb fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group