Re: Are JOINs allowed with DELETE FROM - Mailing list pgsql-performance

From Tom Lane
Subject Re: Are JOINs allowed with DELETE FROM
Date
Msg-id 11561.1107719397@sss.pgh.pa.us
Whole thread Raw
In response to Re: Are JOINs allowed with DELETE FROM  (Steven Rosenstein <srosenst@us.ibm.com>)
Responses Re: Are JOINs allowed with DELETE FROM  (Steven Rosenstein <srosenst@us.ibm.com>)
List pgsql-performance
Steven Rosenstein <srosenst@us.ibm.com> writes:
> Thank you for the link to the documentation page.  I forgot to mention that
> we're still using version 7.3.  When I checked the 7.3 documentation for
> DELETE, there was no mention of being able to use fields from different
> tables in a WHERE clause.  This feature must have been added in a
> subsequent release of PostgreSQL.

No, it's been there all along, if perhaps not well documented.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steven Rosenstein
Date:
Subject: Re: Are JOINs allowed with DELETE FROM
Next
From: Steven Rosenstein
Date:
Subject: Can the V7.3 EXPLAIN ANALYZE be trusted?