"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 regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
