X-Original-To: pgsql-sql@postgresql.org
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id 5517F47634D
	for <pgsql-sql@postgresql.org>; Wed, 12 Mar 2003 15:49:15 -0500 (EST)
Received: (qmail 9207 invoked by uid 500); 12 Mar 2003 21:03:26 -0000
Date: Wed, 12 Mar 2003 15:03:26 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: luca.scaramella@recom.it
Cc: pgsql-sql@postgresql.org
Subject: Re: DELETE FROM A BLACK LIST
Message-ID: <20030312210326.GA9194@wolff.to>
Mail-Followup-To: luca.scaramella@recom.it, pgsql-sql@postgresql.org
References: <OFC425EC90.A6DA753C-ONC1256CE0.003861F2@recom.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <OFC425EC90.A6DA753C-ONC1256CE0.003861F2@recom.it>
User-Agent: Mutt/1.3.25i
X-Archive-Number: 200303/310
X-Sequence-Number: 12349

On Wed, Mar 05, 2003 at 11:27:54 +0100,
  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)

Use:

delete from t1 where t1.id = blacklist.id;