Postgres Pro
Downloads
Home   >   mailing lists

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

From Atsushi Ogawa
Subject Allow an alias for the target table in UPDATE
Date
Msg-id 613787150511280607r1a022990v@mail.gmail.com
Whole thread Raw
Responses Re: Allow an alias for the target table in UPDATE  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: What's wrong with the lists?
Next
From: Tom Lane
Date:
Subject: Re: Using multi-row technique with COPY