"Kevin B." <[EMAIL PROTECTED]> writes: > Select a.i, b.i > from t as a > left join t as b on a.i = b.i > where a.n = 'a' and b.n = 'b' and b.i is null
This can't succeed since the b.n = 'b' condition is guaranteed to fail when b.* is nulled out ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster