Probs with int2 in functions - Mailing list pgsql-sql

From Gordon Clarke
Subject Probs with int2 in functions
Date
Msg-id Pine.LNX.3.96.981227143322.599B-100000@localhost
Whole thread Raw
List pgsql-sql
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?

Cheers...Gordon
~~~~~~~~~~~~~~ 4ZzZ Brisbane's First Community FM Station ~~~~~~~~~~~~~~
         The Demo Show - Supporting Australian Unsigned Artists
            Mon nights 6-7pm (0800-0900UTC) on 4ZzZ 102.1 FM
             http://www.4zzzfm.org.au/welcome.html (RA feed)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] PB with Null string
Next
From: Engard Ferenc
Date:
Subject: Extremely slow update