Re: [SQL] Probs with int2 in functions

Gordon Clarke wrote:
>
> I'm using PostgreSQL v6.3.2.
>
> It appears that the function command doesn't like the type "int2" as a
> parm in a call. For example,
>
> zedadmin=> \i zz.sql
> create table test2(
>   trk_id        int2            not null,
>   trk_nm        varchar(30)     not null,
>   trk_comp      varchar(30));
> CREATE
>
> create function insert_test2(int2,varchar,varchar)
> returns int4 as
>  'insert into test2
>   values($1,$2,$3);
> select 1 as return_val;'
> language 'sql';
> CREATE
> EOF
>
> The objects are successfully created, but when I come to insert data via
> the function there is the following error.
>
> zedadmin=> select insert_test2(1,'My name','My comment');
> ERROR:  function insert_test2(int4, unknown, unknown) does not exist
>
> If one changes the int2 to an int4 in the table and function, the function
> is happy to insert the data into the table.
>
> Any ideas why this is so, or is it a bug?
>

It works on my v6.4:

select insert_test2(1,'My name','My comment');
insert_test2
------------
           1
(1 row)

select * from test2;
trk_id|trk_nm |trk_comp
------+-------+----------
     1|My name|My comment
     1|My name|My comment
(2 rows)

Any way try to cast values as:
select insert_test2(1::int2,'My name'::varchar,'My comment'::varchar);

-Jose'-