When I call the following plpgsql function with the last two parameters
as Null, the first parameter loses it's value: ma=> select createFund('fred', null, null); createfund
------------ (1 row)
However it works fine when I give values to the last two params: ma=> select createFund('fred', 'joe', 5);
createfund ------------ fred (1 row)
Here's the function (I've hacked it so that it just returns the first
parameter): create function createFund(varchar, varchar, int) returns text as ' DECLARE fundname
ALIASFOR $1; fundsymbol ALIAS FOR $2; fundcusip ALIAS FOR $3; existing
varchar(100); fundid int; rec RECORD; retval text;
datecount smallint; BEGIN RETURN fundname; ... END; ' language 'plpgsql';
Any ideas?
-Skeets Norquist
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.