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