pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gordon Clarke <gordonc@cyberbiz.net.au>
To: sferac@bo.nettuno.it
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Probs with int2 in functions
Date: Sun, 3 Jan 1999 16:02:35 +1000 (EST)
Message-ID: <Pine.LNX.3.96.990103145848.649B-100000@localhost> (raw)
In-Reply-To: <3688E133.CB661A68@sferacarta.com>

On Tue, 29 Dec 1998, Jose' Soares wrote:

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

So it appear that it is a bug in 6.3.2!

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

I'd prefer not to do that. Also, since it isn't necessary for the int4
case then it shouldn't be for the int2 case and this suggests to me that
it is a bug.

Thanks for your suggestions and help.

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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





view thread (4+ messages)  latest in thread

Message-ID: <Pine.LNX.3.96.990103145848.649B-100000@localhost>
Permalink:  ../Pine.LNX.3.96.990103145848.649B-100000@localhost/
Also on:    postgresql.org/message-id/Pine.LNX.3.96.990103145848.649B-100000@localhost

 · 

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: gordonc@cyberbiz.net.au, sferac@bo.nettuno.it
  Subject: Re: [SQL] Probs with int2 in functions
  In-Reply-To: <Pine.LNX.3.96.990103145848.649B-100000@localhost>
  References: <3688E133.CB661A68@sferacarta.com> <Pine.LNX.3.96.990103145848.649B-100000@localhost>

* 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