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 such an optional FROM clause. --------------------------------------------------------------------------- =Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
