Delete from Join - Mailing list pgsql-general

From Gwyneth Morrison
Subject Delete from Join
Date
Msg-id 486B9B9D.4050204@toadware.ca
Whole thread Raw
Responses Re: Delete from Join
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg crashing
Next
From: jcvlz
Date:
Subject: Re: simple tool for building web forms