Re: Are JOINs allowed with DELETE FROM

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Steven Rosenstein <srosenst(at)us(dot)ibm(dot)com>
Subject: Re: Are JOINs allowed with DELETE FROM
Date: 2005-02-06 17:36:03
Message-ID: 42065583.6010304@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Steven Rosenstein wrote:
> DELETE FROM detail JOIN summary ON (summary.id=detail.sum_id) WHERE
> collect_date='2005-02-05';

DELETE FROM detail WHERE detail.sum_id in ( select id from summary )
AND collect_date='2005-02-05';

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2005-02-06 17:50:29 Re: Are JOINs allowed with DELETE FROM
Previous Message Dirk Lutzebaeck 2005-02-06 17:26:30 Re: query produces 1 GB temp file