Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >>> * Allow an alias to be provided for the target table in UPDATE/DELETE > > > Yea, I guess for a long table that also needed an alias you would have > > to specify the long name every time you reference the table. However, > > we haven't had anyone ask for that capability, > > Yes we have. Do I need to trawl the archives for you? It's been asked > for quite a few times.
OK, TODO updated: * Allow an alias to be provided for the target table in UPDATE/DELETE This is not SQL-spec but many DBMSs allow it. * Allow additional tables to be specified in DELETE for joins UPDATE already allows this (UPDATE...FROM) but we need similar functionality in DELETE. It's been agreed that the keyword should be USING, to avoid anything as confusing as DELETE FROM a FROM b. -- 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 6: Have you searched our list archives? http://archives.postgresql.org
