Thread: Allow an alias for the target table in UPDATE

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.

--- Atsushi Ogawa

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