> This is great, we thought we may go for code changes, we will go with this > solution instead.
But you did catch Stephan's point that an outer join is not required to produce the result you apparently want? The equivalent inner join will be at worst just as fast, and possibly faster, both for PostgreSQL and for Oracle... - Thomas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]