On Wed, Aug 17, 2016 at 10:38 AM, Greg Stark <stark@mit.edu> wrote:
> You can't have joins in a DELETE -- which table would it actually
> delete from? You can use a subselect to do look up information from
> other tables in your delete though.
We've supported having joins in a DELETE since PostgreSQL 8.1.
https://www.postgresql.org/docs/8.1/static/sql-delete.html
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
