Mathieu Fenniak <mathieu(at)fenniak(dot)net> writes:
> After running the attached setup.sql.gz SQL script on a PostgreSQL  
> 8.4.0 database, the following two queries which should be logically  
> identical return different results.  As far as I can tell from the  
> query analysis, the LEFT JOIN on query A is happening after  
> "ee.projectid = pc.projectid" is filtered; therefore the rows where  
> projectid is NULL are not visible in query A.

This should fix it.  Thanks for the report!

			regards, tom lane

In response to

• Bug 4906 -- Left join of subselect incorrect at 2009-07-20 19:47:03 from Mathieu Fenniak

Responses

• Re: Bug 4906 -- Left join of subselect incorrect at 2009-07-21 13:16:12 from Mathieu Fenniak

pgsql-bugs by date

Next:	From: Pavel Stehule	Date: 2009-07-21 06:13:45
	Subject: Re: fix: plpgsql: return query and dropped columns problem
Previous:	From: Tom Lane	Date: 2009-07-21 01:48:29
	Subject: Re: BUG #4929: Corrupted pg_class, possibly truncate/rollback related