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
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 |