Hi All,
Following test returns wrong result ..
Testcase ( on 8.4 cvs head )
=======================
CREATE OR REPLACE FUNCTION f1(retval VARCHAR DEFAULT 'Argument') RETURNS
VARCHAR as
$$
BEGIN
return retval;
END;
$$ LANGUAGE plpgsql;
CREATE OR REPLACE FUNCTION f2(p1 IN int, p2 IN VARCHAR DEFAULT f1())
RETURNS VARCHAR AS
$$
BEGIN
RETURN p2;
END;
$$ LANGUAGE plpgsql;
postgres=# select f2(10);
f2
----
(1 row)
When we run the f2() it should return the output as the defvalue of f1()
function, but its returning null.
Thanks,
Rushabh Lathia
www.EnterpriseDB.com