=?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman(at)gmail(dot)com> writes:
> I mean query like:
> select id from foo where id not in ( select id from bar);
> select f.id from foo f left join bar b on f.id=b.id where b.id is null;
Postgres does not do that, because they don't mean the same thing ---
the behavior for NULLs in bar.id is different.
8.4 does understand that NOT EXISTS is an antijoin, though.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Grzegorz Jaśkiewicz||Date: 2009-02-20 15:39:56|
|Subject: Re: not in(subselect) in 8.4|
|Previous:||From: Matthew Wakeling||Date: 2009-02-20 15:26:43|
|Subject: Re: SSD performance|