> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> writes: > > I am getting NO DATA on queries that attempt to match one of the "outer" > > rows generated by an outer join. > > Your test case works fine for me on CVS HEAD and 8.2 branch tip. I > think it is another manifestation of this bug: > http://archives.postgresql.org/pgsql-bugs/2007-05/msg00187.php > which was fixed here: > http://archives.postgresql.org/pgsql-committers/2007-05/msg00305.php
I installed postgresql-snapshot.tar.bz2 2007-07-03 10:18:42 from stable_snapshot and confirm that the problem does not reproduce there. (I assume that this snapshot is 8.2 branch tip and CVS HEAD is 8.3 dev?) Thanks, -- David Flater, National Institute of Standards and Technology, U.S.A. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
