Re: Add Missing From?

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