Postgres Pro
Downloads
Home   >   mailing lists

Re: Are JOINs allowed with DELETE FROM - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: Are JOINs allowed with DELETE FROM
Date
Msg-id 42065583.6010304@bigfoot.com
Whole thread Raw
In response to Are JOINs allowed with DELETE FROM  (Steven Rosenstein <srosenst@us.ibm.com>)
Responses Re: Are JOINs allowed with DELETE FROM  (John Arbash Meinel <john@arbash-meinel.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: query produces 1 GB temp file
Next
From: Michael Fuhr
Date:
Subject: Re: Are JOINs allowed with DELETE FROM