On Wed, Aug 17, 2016 at 10:38 AM, Greg Stark <st...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers