On Wed, Feb 05, 2003 at 01:02:53PM -0800, John Smith wrote:
>
> I thought I saw a doc somewhere showing alternatives to using IN() for better performance, but can't find it :(. Are
therebetter performing query alternatives to this?
>
> delete from tab1 where id in (select id2 from tab2 where ...);
Depending on what you're doing, postgres has an extension of SQL
DELETE FROM tab1 WHERE id=tab2.id2 AND tab2.somefield [some
condition].
At least, this has worked for me.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110