[SQL] plpgsql function gets wierd with Null parameters

[Skeets and Kim Norquist]

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.