From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Greg Stark <stark(at)mit(dot)edu>, Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCH] pg_sleep(interval) |
Date: | 2013-08-16 20:16:58 |
Message-ID: | 520E88BA.8000504@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 8/16/13 3:35 PM, Robert Haas wrote:
> On Fri, Aug 16, 2013 at 2:57 PM, Greg Stark <stark(at)mit(dot)edu> wrote:
>> Except there are no data types that can be cast to both double and
>> interval currently.
>
> That, unfortunately, is not sufficient to avoid a problem.
>
> rhaas=# create or replace function foo(double precision) returns
> double precision as $$select $1$$ language sql;
> CREATE FUNCTION
> rhaas=# create or replace function foo(interval) returns interval as
> $$select $1$$ language sql;
> CREATE FUNCTION
> rhaas=# select foo('123');
> ERROR: function foo(unknown) is not unique
> LINE 1: select foo('123');
> ^
> HINT: Could not choose a best candidate function. You might need to
> add explicit type casts.
That example can be used as an argument against almost any kind of
overloading.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2013-08-16 20:19:35 | Re: pg_ctl initdb takes options, but pg_ctl --help doesn't document them? |
Previous Message | Tomas Vondra | 2013-08-16 19:47:51 | Re: pgstat_reset_remove_files ignores its argument |