Re: Add Missing From?

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073