the foo bar example above, with notion that all columns are NOT NULL
behaves much different now. I noticed, that some of the 'anti join'
stuff has changed in cvs recently, but I don't know if that's to
blame.
Basically, what I can see, is that the subselect case is no longer of
lower cost, to the left join - but is quite substantially more
expensive.
Just an observation, I don't intend to use subselects anyhow, because
these are very much slower on 8.3, which we use in production here.