Re: Add Missing From?

I have added the USING mention to the TODO list description for the
item.

* Allow DELETE to handle table aliases for self-joins [delete]
 There is no way to specify a table alias for the deleted table in the DELETE WHERE clause because there is no FROM
clause.The agreed approach is to allow a USING clause to specify additional tables with aliases.  UPDATE already has
suchan optional FROM clause.
 


---------------------------------------------------------------------------

=Tom Lane wrote:
> Jan Wieck <JanWieck@Yahoo.com> writes:
> > What about
> > DELETE FROM staff JOIN users ...
> > then?
> 
> I don't much care for that, mainly because in my mind "x JOIN y" should
> always be semantically equivalent to "y JOIN x".  I think we want a real
> clear syntactical separation between the deletion target table and the
> other tables.
> 
> Also we do have the precedent of the way that UPDATE does things.  We
> don't want to use the keyword FROM because of confusion, but I think
> we want to keep it basically the same as UPDATE.
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 

--  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