Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 is to 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 [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 7: don't forget to increase your free space map settings
