> I read your mail once again, but I still don't understand what are
> talking about.
> I'll write example - maybe it will help us to understand each other.
Hmmm ... you're right. Sorry for being dense. It shouldn't work, but
If I run the query:
FROM table1 t1
LEFT JOIN table2 t2 ON t1.xid = t2.xid
WHERE t2.label IS NULL
I will get rows in t1 for which there is no row in t2. This does not
seem SQL-spec to me; shouldn't I get only rows from t1 where a row
exists in t2 and t2.label IS NULL?
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2002-12-20 00:02:13|
|Subject: Re: EXISTS vs IN vs OUTER JOINS |
|Previous:||From: Bruce Momjian||Date: 2002-12-19 22:52:24|
|Subject: Re: EXISTS vs IN vs OUTER JOINS|