[GENERAL] Delete from Join

[Gwyneth Morrison]

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
             

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general