Re: Delete from Join

--- On Wed, 7/2/08, Gwyneth Morrison <postgres@toadware.ca> wrote:

> From: Gwyneth Morrison <postgres@toadware.ca>
> Subject: [GENERAL] Delete from Join
> To: pgsql-general@postgresql.org
> Date: Wednesday, July 2, 2008, 3:15 PM
> Hello,
>
> Is it possible to use a join keyword in a delete?
>
> For example:
>
>      DELETE FROM data_table1
>                 using data_table2 INNER JOIN
>                         data_table1  ON data_table1.fkey =
> data_table2.pkey;
>
>
> It is not directly mentioned in the delete syntax but the
> delete refers
> to the select clause where JOIN is valid.
>
> G
>

i have a example

delete from t1 a using t2 b where a.id = b.oid

A standard way to do it is

delete from t1 a where id in (select a.id from t1 a inner join t2 b on (a.id = b.oid))