[HACKERS] Function with default value not replacing old definition of the function

[Rushabh Lathia]

Hi,

Testcase: (8.4 CVS head)
====================

CREATE OR REPLACE FUNCTION myfunc(y int)
RETURNS INTEGER AS $$
   select  100;
$$ language sql;

CREATE OR REPLACE FUNCTION myfunc(y int, x integer DEFAULT 100)
RETURNS INTEGER AS $$
   select  200;
$$ language sql;

select myfunc(10);

 myfunc
----------
      100
(1 row)

When create the same function again by added one default value, while
calling the function old function getting called.

It seems that, function with defval not making any sense, if we want to call
the new function then we need to pass defval as well.

select myfunc(10,10);

 myfunc
----------
      200
(1 row)

I think second function should replace the old definition of the function,
inputs ?


Thanks,
Rushabh Lathia
www.EnterpriseDB.com