Re: some problem with casting unknown to smallint

2008/10/29 Tom Lane :
> "Pavel Stehule"  writes:
>> I am not sure, it's probably bug.
>
>> postgres=# create function t1(smallint) returns smallint as $$select
>> $1$$ language sql;
>> CREATE FUNCTION
>> postgres=# select t1(10);
>> ERROR:  function t1(integer) does not exist
>
> That's not "unknown to smallint", that's "integer to smallint",
> which is not an implicit cast.
>
> unknown to smallint would be t1('10')
>

I understand. So every smallint should be call with casting?

regards
Pavel Stehule


>                        regards, tom lane
>