BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

Поиск
Список
Период
Сортировка
От chmelarp@fit.vutbr.cz
Тема BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL
Дата
Msg-id E1V20Jm-0002iy-BQ@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL  (bricklen <bricklen@gmail.com>)
Re: BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8329
Logged by:          Petr
Email address:      chmelarp@fit.vutbr.cz
PostgreSQL version: 9.2.4
Operating system:   Fedora x64
Description:

Hi there,
we have an issue - if I run a query from a console, it runs OK. When it is
run using EXECUTE in an PL/pgSQL function, it sets NULL. The simplest
version of the query is like this:
UPDATE x
SET x.y = x.y + z.
FROM (SELECT z) as Z
WHERE ... ;


If I don't use the "+" in the SET command, it works OK. The whle query is
quite complex, but OK in a console. If you need the query an tables..., mail
me, please. I can't make it public.

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

Предыдущее
От: Terje Elde
Дата:
Сообщение: Re: Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.
Следующее
От: bricklen
Дата:
Сообщение: Re: BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL