Re: Allow an alias for the target table in UPDATE/DELETE

Поиск
Список
Период
Сортировка
От Atsushi Ogawa
Тема Re: Allow an alias for the target table in UPDATE/DELETE
Дата
Msg-id 613787150512021742p1d2a4eeby@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Allow an alias for the target table in UPDATE/DELETE  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Allow an alias for the target table in UPDATE/DELETE  (Neil Conway <neilc@samurai.com>)
Список pgsql-patches
Thanks for comments. I modified the patch.

Tom Lane wrote:
> 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.

I stop applying an alias to a SET target.

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

OK. I changed the syntax rule of an alias of UPDATE/DELETE target from
ColId to IDENT. This doesn't change reserved words though candidates
of that alias decreases.

--- Atsushi Ogawa

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Numeric 508 datatype
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Numeric 508 datatype