Re: BUG #1528: Rows returned that should be excluded by WHERE clause

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Peter Wright" <pete@flooble.net>
Cc: pgsql-bugs@postgresql.org
Date: 2005-03-10T23:49:47Z
Lists: pgsql-bugs, pgsql-hackers
"Peter Wright" <pete@flooble.net> writes:
> I think this demonstrates the problem much better than I could explain in
> words. The bug is shown in the two
> SELECT queries with a WHERE clause. Very bizarre.

I've applied a patch that corrects this problem in CVS HEAD, but since
it changes the behavior of HAVING in a nontrivial way, I'm inclined to
think that we should not backpatch it into existing release branches.

			regards, tom lane