Postgres Pro
Downloads
Home   >   mailing lists

Re: Allow an alias for the target table in UPDATE/DELETE - Mailing list pgsql-patches

From Tom Lane
Subject Re: Allow an alias for the target table in UPDATE/DELETE
Date
Msg-id 11388.1133453112@sss.pgh.pa.us
Whole thread Raw
In response to Allow an alias for the target table in UPDATE/DELETE  (Atsushi Ogawa <atsushi.ogawa@gmail.com>)
Responses Re: Allow an alias for the target table in UPDATE/DELETE  (Atsushi Ogawa <atsushi.ogawa@gmail.com>)
List pgsql-patches
Tree view 
Atsushi Ogawa <atsushi.ogawa@gmail.com> writes:
> (2)About processing when column identifier of SET clause is specified
> like 'AAA.BBB'. 'AAA' is a composite column now. When an alias for
> target table is supported, 'AAA' is a composite column or a table.
> How do we distinguish these?

You don't, which is why you can't put an alias on a SET target.

Increasing the reserved-ness of SET isn't real attractive either.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Check for integer overflow in datetime functions
Next
From: Tom Lane
Date:
Subject: Re: Check for integer overflow in datetime functions