Re: Functions just dont want to work! [hard]

> Problem is that 24 is not an int2 -- it's an int4 (generic int type).
> For example:
>

Yes it is ... int2 is a two byte integer, meaning it has a range from
-32768 to +32767. Unless I totally mistaken, 24 falls within that range.

Am I missing something vital to this problem? What you have said seems
incorrect to me.

> joel(at)joel=# create function hi(int2) returns bool as 'begin return true;
> end;' language 'plpgsql';
> CREATE FUNCTION
> joel(at)joel=# select hi(42);
> ERROR: Function hi(integer) does not exist
> Unable to identify a function that satisfies the given argument types
> You may need to add explicit typecasts
>

It works fine for me:

test=# create function hi(int2) returns bool as 'begin return true;
test'# end;' language 'plpgsql';
CREATE
test=# select hi(42);
hi
----
t
(1 row)

test=#

What version are you using?

Andy