Re: Function with defval returns error

"Rushabh Lathia" <rushabh.lathia@gmail.com> writes:
>    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...

This is fixed in my recent commit --- the ambiguous-function error won't
occur unless the ambiguous functions represent the best match to the
actual arguments.
        regards, tom lane