Re: plpgsql function not accepting NULL value

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;
> x_developer_id alias for $2;
> x_client_id alias for $3;
> x_project_id alias for $4;
> x_rate alias for $5;
> x_rate_id alias for $6;
> x_meta_id alias for $7;
> begin
> perform update_lastmod (x_meta_id, x_admin_id);
> update rates_tbl set
> developer_id = x_developer_id ,
> client_id = x_client_id ,
> project_id = x_project_id ,
> rate = x_rate
> where rate_id = x_rate_id ;
> return ;
> end;
> ' language plpgsql;
>
>
> invoicer=> select update_rate(1, 1, 10, NULL, numeric '90.00', 6, 216);
> ERROR: function update_rate(integer, integer, integer, "unknown",
> numeric, integer, integer) does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts.

Umm, it looks to me like you're trying to pass 7 parameters to a function
that takes 6 in the above.