> 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 =
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.
In response to
pgsql-performance by date
|Next:||From: Hilary Forbes||Date: 2005-09-12 09:14:25|
|Subject: Slow update|
|Previous:||From: John A Meinel||Date: 2005-09-12 04:58:34|
|Subject: Re: Prepared statement not using index|