Probs with int2 in functions

From: Gordon Clarke <gordonc(at)cyberbiz(dot)net(dot)au>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Probs with int2 in functions
Date: 1998-12-27 06:56:05
Message-ID: Pine.LNX.3.96.981227143322.599B-100000@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Engard Ferenc 1998-12-27 21:55:49 Extremely slow update
Previous Message Herouth Maoz 1998-12-23 09:37:44 Re: [GENERAL] PB with Null string