some problem with casting unknown to smallint

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "postgres hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: some problem with casting unknown to smallint
Date: 2008-10-29 08:07:01
Message-ID: 162867790810290107q73e2c40cre30aa492d5af52e0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

I am not sure, it's probably bug.

postgres=# create function t1(smallint) returns smallint as $$select
$1$$ language sql;
CREATE FUNCTION
postgres=# create function t2(bigint) returns bigint as $$select $1$$
language sql;
CREATE FUNCTION
postgres=# select t1(10);
ERROR: function t1(integer) does not exist
LINE 1: select t1(10);
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts.

but
postgres=# select t2(10);
t2
----
10
(1 row)

Regards
Pavel Stehule

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce McAlister 2008-10-29 08:11:05 Re: UUID-OSSP Contrib Module Compilation Issue
Previous Message Hannu Krosing 2008-10-29 07:54:12 Re: PostgreSQL + Replicator developer meeting 10/28