From: | Skeets and Kim Norquist <norqu2(at)juno(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | plpgsql function gets wierd with Null parameters |
Date: | 2000-06-28 18:27:53 |
Message-ID: | 20000628.112753.-439695.1.norqu2@juno.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 ALIAS FOR $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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Swan | 2000-06-28 18:50:45 | Finding the names of inheriting classes |
Previous Message | Philip Hallstrom | 2000-06-28 18:13:32 | Re: retrieving a serial number |