Re: Allow an alias for the target table in UPDATE - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Allow an alias for the target table in UPDATE
Date
Msg-id 200511290139.jAT1dMC01653@candle.pha.pa.us
Whole thread Raw
In response to Allow an alias for the target table in UPDATE  (Atsushi Ogawa <atsushi.ogawa@gmail.com>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Hashjoin startup strategy (was Re: Getting different number of results when using hashjoin on/off)
Next
From: Bruce Momjian
Date:
Subject: Checking a heap page