Re: Are JOINs allowed with DELETE FROM

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steven Rosenstein <srosenst(at)us(dot)ibm(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Are JOINs allowed with DELETE FROM
Date: 2005-02-06 19:49:57
Message-ID: 11561.1107719397@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Steven Rosenstein <srosenst(at)us(dot)ibm(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steven Rosenstein 2005-02-06 19:50:56 Can the V7.3 EXPLAIN ANALYZE be trusted?
Previous Message Steven Rosenstein 2005-02-06 19:33:16 Re: Are JOINs allowed with DELETE FROM