Re: UPDATE ... SET (a, b, c) = (expr)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: UPDATE ... SET (a, b, c) = (expr)
Дата
Msg-id 4087.1250867036@sss.pgh.pa.us
обсуждение исходный текст
Ответ на UPDATE ... SET (a, b, c) = (expr)  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> So is this the right way to approach the problem, or am I missing some
> simpler way?

See discussions of NikhilS's patch last year.  I think the conclusion we
had arrived at was that we should refactor the representation of SubLink
so that a single-row subselect could be responsible for producing the
values of more than one Param (located in more than one place in the
query's expression trees).  Otherwise you get into having to redefine
the representation of targetlists, which will break more code than is
pleasant to think about.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Geometric Elimination
Следующее
От: Jean-Michel Pouré
Дата:
Сообщение: Feedback about Drupal SQL debugging