Re: Allow an alias for the target table in UPDATE

Atsushi Ogawa wrote:
> I am interested in a following item in TODO.
> 
> o Allow an alias to be provided for the target table in
>   UPDATE/DELETE
>   This is not SQL-spec but many DBMSs allow it.
> 
> I think that this functionality is useful for the migration from
> other RDBMS. However the SQL92 spec does not allow an alias for
> the target table in UPDATE.
> Is it still TODO? If it is TODO, I will try it.

Yes, this is still a valid TODO item.

--  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