delete from t1 where not exists (select blacklist.id from blacklist where
blacklist.id=t1.id);
(if I recall the full syntax correctly - you get the idea: use "exists")
Cheers,
Steve
On Wednesday 05 March 2003 2:27 am, luca.scaramella@recom.it wrote:
> Hi all,
> I have a Blacklist table containing about 1000 ID to delete from another
> table (T1 about 1440294 records)
> If i use the SQL
>
> DELETE FROM T1 WHERE T1.ID IN (SELECT BLACKLIST.ID FROM BLACKLIST)
>
> the operation is very slow .
>
> There is a faster way to do the same operation??
>
> Thanks
> Luca
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)