Re: some problem with casting unknown to smallint

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

"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')

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2008-10-29 12:31:46 Re: some problem with casting unknown to smallint
Previous Message Heikki Linnakangas 2008-10-29 12:12:23 Re: Updating FSM on recovery