Re: [SQL] plpgsql function not accepting NULL value

2005-09-16 Thread Kenneth Dombrowski
On 9/16/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Fri, Sep 16, 2005 at 07:04:39PM -0400, Kenneth Dombrowski wrote: > > create or replace function update_rate (integer, integer, integer, > > integer, numeric, integer) > > You've created a function with six arguments. > > > invoicer=

Re: [SQL] plpgsql function not accepting NULL value

2005-09-16 Thread Michael Fuhr
On Fri, Sep 16, 2005 at 07:04:39PM -0400, Kenneth Dombrowski wrote: > create or replace function update_rate (integer, integer, integer, > integer, numeric, integer) You've created a function with six arguments. > invoicer=> select update_rate(1, 1, 10, NULL, numeric '90.00', 6, 216); > E

Re: [SQL] plpgsql function not accepting NULL value

2005-09-16 Thread Stephan Szabo
On Fri, 16 Sep 2005, Kenneth Dombrowski wrote: > I can't get this one to work at all: > > create or replace function update_rate (integer, integer, integer, > integer, numeric, integer) > returns void > as ' > declare > x_admin_id alias for $1; >

[SQL] plpgsql function not accepting NULL value

2005-09-16 Thread Kenneth Dombrowski
Hi, I'm using the postgresql 7.4.7-6sarge1 package from debian stable. I am confused about these two functions, and their behavior when being given NULL values in place of a parameter declared as integer: This one works as expected: create or replace function insert_rate (integer, integer, in