pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jose' Soares <jose@sferacarta.com>
To: Gordon Clarke <gordonc@cyberbiz.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Probs with int2 in functions
Date: Tue, 29 Dec 1998 15:03:31 +0100
Message-ID: <3688E133.CB661A68@sferacarta.com> (raw)
References: <Pine.LNX.3.96.981227143322.599B-100000@localhost>

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'-



view thread (4+ messages)  latest in thread

Message-ID: <3688E133.CB661A68@sferacarta.com>
Permalink:  ../3688E133.CB661A68@sferacarta.com/
Also on:    postgresql.org/message-id/3688E133.CB661A68@sferacarta.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jose@sferacarta.com, gordonc@cyberbiz.net.au
  Subject: Re: [SQL] Probs with int2 in functions
  In-Reply-To: <3688E133.CB661A68@sferacarta.com>
  References: <Pine.LNX.3.96.981227143322.599B-100000@localhost> <3688E133.CB661A68@sferacarta.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox