Function with defval returns error
От | Rushabh Lathia |
---|---|
Тема | Function with defval returns error |
Дата | |
Msg-id | 460abcb10812150104lc779517ofbfcbb4890fca9f7@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Function with defval returns error
Re: Function with defval returns error Re: Function with defval returns error |
Список | pgsql-hackers |
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>
В списке pgsql-hackers по дате отправления: