Received: from cyberbiz.net.au ([202.138.13.144]) by hub.org (8.9.1/8.9.1) with SMTP id BAA05964 for ; Sun, 27 Dec 1998 01:57:42 -0500 (EST) (envelope-from gordonc@cyberbiz.net.au) Received: from localhost [202.138.13.155] by cyberbiz.net.au [202.138.13.144] with SMTP (MDaemon.v2.7.SP5k.R) for ; Sun, 27 Dec 1998 16:54:37 +1000 Date: Sun, 27 Dec 1998 16:56:05 +1000 (EST) From: Gordon Clarke X-Sender: gordonc@localhost Reply-To: Gordon Clarke To: pgsql-sql@postgreSQL.org Subject: Probs with int2 in functions Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-MDaemon-Deliver-To: pgsql-sql@postgreSQL.org X-Return-Path: gordonc@cyberbiz.net.au 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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~