Re: passing values to a function

> > Why does this not work? Am I doing something wrong?
..
> > raise notice '' varop is '',varop;
>
> raise notice '' varop is %'', varop;

Arrrg! How did I miss that one.. I've been writing notice lines for
months now!

Ok, well I seem to have found the "real" problem this time ;)

CREATE FUNCTION update_sentitems(text,int4) RETURNS bool AS '
declare
varop alias for $1;
begin
raise notice '' varop = %'',varop;
return false;
end;
' LANGUAGE 'plpgsql';

Giving
select update_sentitems('INSERT',1);
returns
NOTICE: varop = INSERT
as expected, however if you give
select update_sentitems('INSERT',null);
this is returned:
NOTICE: varop = <NULL>

BTW, it doesn't matter if both parameters are text or int4. Also, it
doesn't matter which one is given as null, they both turn up null.
Bottom line seems to be that if you call the function with any parameter
null, they are all null. Sooo.. what's up here? Is this a bug that's
been fixed in 7.0.3? (I'm still using 7.0.2).

Thanks
-Cedar