Re: find the "missing" rows - Mailing list pgsql-sql

From Tom Lane
Subject Re: find the "missing" rows
Date
Msg-id 28993.1101952391@sss.pgh.pa.us
Whole thread Raw
In response to find the "missing" rows  ("Kevin B." <db@ke5in.com>)
List pgsql-sql
"Kevin B." <db@ke5in.com> 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


pgsql-sql by date:

Previous
From: Johan Henselmans
Date:
Subject: Re: grouping a many to many relation set
Next
From: Michael Fuhr
Date:
Subject: Re: Found Large Files.. what objects are they?