Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > There is no way to specify a table alias for the deleted table in
> > the DELETE WHERE clause because there is no FROM clause.
>
> This description confuses two quite separate issues.
Yea, it does.
How is this text:
* Allow DELETE to handle table aliases for self-joins
There is no way to create a table alias for the deleted table for use in the DELETE WHERE clause. The agreed approach
isto allow a USING clause to specify additional tables. UPDATE already has an optional FROM clause for this purpose.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073