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

On Wed, Jul 24, 2013 at 7:45 AM, <chmelarp(at)fit(dot)vutbr(dot)cz> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 8329
> Logged by: Petr
> Email address: chmelarp(at)fit(dot)vutbr(dot)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.
>

Can you reduce it to a simpler test case without the details you are not
able to show? Statistically it is more likely there is an error in your
plpgsql function than in postgres itself.
Also, is the "z." a typo, or is there really a dot after the "z"?