Postgres Pro
Downloads
Home   >   mailing lists

Re: slow query - where not in - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: slow query - where not in
Date
Msg-id 20030328175356.GA12549@wolff.to
Whole thread Raw
In response to Re: slow query - where not in  ("Michael Paesold" <mpaesold@gmx.at>)
Responses Re: slow query - where not in
List pgsql-performance
Tree view 
On Fri, Mar 28, 2003 at 17:53:46 +0100,
  Michael Paesold <mpaesold@gmx.at> wrote:
> Bruno Wolff III <bruno@wolff.to> wrote:
>
> I think this should rather be:
>
> SELECT shoporder FROM sodetailtabletrans
>   WHERE NOT EXISTS (
>     SELECT 1 FROM soheadertable
>     WHERE soheadertable.shoporder = sodetailtabletrans.shoporder
>     )

Thanks for catching my mistake.

pgsql-performance by date:

Previous
From: Ulli Mueckstein
Date:
Subject: calling analyze from a stored procedure in C
Next
From: Jeremiah Elliott
Date:
Subject: Re: slow query - where not in