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