Re: [GENERAL] function param and declared variable of same name

2011-09-01 Thread Sim Zacks
On 09/01/2011 09:58 AM, Pavel Stehule wrote: 2011/9/1 Sim Zacks : Tested in 8.2 and 9.0.1 In plpgsql, if you have a function parameter and a variable of the same name, it ignores the value passed in and initializes the variable to null. The correct action, IM

[GENERAL] function param and declared variable of same name

2011-08-31 Thread Sim Zacks
Tested in 8.2 and 9.0.1 In plpgsql, if you have a function parameter and a variable of the same name, it ignores the value passed in and initializes the variable to null. The correct action, IMO, would be to raise an error. create or replace function test1(x int