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