Hi All,<br /><br />Following test returns error on 8.4 cvs head. it looks like an issue<br /><br clear="all"
/>Testcase:(8.4 CVS head)<br />====================<br /> CREATE OR REPLACE FUNCTION f007( a INTEGER, <br
/> b INTEGER DEFAULT 10 ) RETURNS INTEGER <br /> AS $$ <br /> select 10; <br /> $$ language sql;
<br/><br /> CREATE OR REPLACE FUNCTION f007( a INTEGER DEFAULT 10, <br /> b INTEGER DEFAULT 10, <br
/> c INTEGER DEFAULT 10) RETURNS INTEGER <br /> AS $$ <br /> select 10; <br /> $$ language sql; <br
/><br/> CREATE OR REPLACE FUNCTION f007( a TIMESTAMP DEFAULT to_date('01-JUN-06 14:03:50', 'DD-MON-YY HH24:MI:SS') )
RETURNSTIMESTAMP <br /> AS $$ <br /> select current_date::timestamp; <br /> $$ language sql; <br /><br
/>postgres=#SELECT f007( to_date('01-JUN-06 14:03:50', 'DD-MON-YY HH24:MI:SS') ); <br />ERROR: functions with
parameterdefaults f007(integer, integer, integer) and f007(integer, integer) are ambiguous <br /><br /><br />I think
thisshould not return error as the input args here is timestamp... inputs?<br /><br />Thanks,<br />Rushabh Lathia<br
/><ahref="http://www.EnterpriseDB.com">www.EnterpriseDB.com</a>