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