Message-ID: <43250CE1.6090602@arbash-meinel.com>
Date: Mon, 12 Sep 2005 01:06:41 -0400
From: John A Meinel <john@arbash-meinel.com>
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
MIME-Version: 1.0
To: Kevin <kev@drule.org>
Cc: arnaulist@andromeiberica.com, pgsql-performance@postgresql.org
Subject: Re: Advise about how to delete entries
References: <43183AC9.1060704@andromeiberica.com>
 <op.swhh87t5th1vuj@localhost>
	<431C0F48.5050809@andromeiberica.com> <431D77F5.4070307@drule.org>
In-Reply-To: <431D77F5.4070307@drule.org>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enigDD752B50F7A119A757208707"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigDD752B50F7A119A757208707
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Kevin wrote:
> Arnau wrote:
>
>> Hi all,
>>
>> >
>> >     COPY FROM a file with all the ID's to delete, into a temporary
>> table, and  do a joined delete to your main table (thus, only one query).
>>
>>
>>   I already did this, but I don't have idea about how to do this join,
>> could you give me a hint ;-) ?
>>
>> Thank you very much
>
>
> maybe something like this:
>
> DELETE FROM statistics_sasme s
>     LEFT JOIN temp_table t ON (s.statistic_id = t.statistic_id)
> WHERE t.statistic_id IS NOT NULL
>

Why can't you do:
DELETE FROM statistics_sasme s JOIN temp_table t ON (s.statistic_id =
t.statistic_id);

Or possibly:

DELETE FROM statistics_sasme s
      WHERE s.id IN (SELECT t.statistic_id FROM temp_table t);

I'm not sure how delete exactly works with joins, but the IN form should
be approximately correct.

John
=:->


--------------enigDD752B50F7A119A757208707
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (Darwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDJQzhJdeBCYSNAAMRAlMQAJ9M4gp+3FwiIiWvqIi9dNfZnhGycgCaAtir
BVTS7qLnC8m6Sk5OZOz+iag=
=FfAs
-----END PGP SIGNATURE-----

--------------enigDD752B50F7A119A757208707--