Re: some problem with casting unknown to smallint

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "postgres hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: some problem with casting unknown to smallint
Date: 2008-10-29 12:31:46
Message-ID: 162867790810290531j632a5336of4846cbe2331e7bb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2008/10/29 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> 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
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-29 12:36:54 Re: Updating FSM on recovery
Previous Message Tom Lane 2008-10-29 12:21:02 Re: some problem with casting unknown to smallint