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

2013-08-11 Thread Petr Chmelar
), where it gives 1 where are NULL and 1 in column x. Probably you should introduce coalesce() here. Thank you, Petr On 29.7.2013 22:55, Petr Chmelar wrote: Dear Pavel and Andrew, avoiding the nulls solves the thing - thank you! I was considering NULL as 0... lame. I just wonder why i

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

2013-07-29 Thread Petr Chmelar
Dear Pavel and Andrew, avoiding the nulls solves the thing - thank you! I was considering NULL as 0... lame. I just wonder why it was working in the console, but it is not important - at the moment it works just fine. Cheers, Petr On 27.7.2013 22:59, Pavel Stehule wrote: Hello 2013/7/27 An

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

2013-07-24 Thread Petr Chmelar
Dear Briklen and Pavel, Yes, the z. is a typo, it should be z.z ... I can send the complete query and tables tomorrow, also I'll try to make it simpler (the function is about 300 lines). Thanks for the early answers, Petr Dne 24.07.2013 17:14 napsal uživatel bricklen: On Wed, Jul 24, 2013 at 7