Re: DELETE FROM A BLACK LIST

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(dot)scaramella(at)recom(dot)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(at)postgresql(dot)org)