pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jackson, DeJuan <djackson@cpsgroup.com>
To: 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: Mon, 4 Jan 1999 17:40:56 -0600
Message-ID: <F10BB1FAF801D111829B0060971D839F5B06DA@cpsmail> (raw)

Well, it's not really a bug.  It's the lack of a feature.  Constant
integers are simply int4's not int2's and in pre-v6.4 the was no
auto-type coercion.  The key here is 'auto'.  If there was no type
coercion I'd have to agree that it was a bug.  But simply because the
developers didn't assume that they know what I want better than I do,
doesn't make it a bug.
So, you have to specify type conversions yourself.  If you want your
function to work as is upgrade.
	-DEJ

> -----Original Message-----
> 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



view thread (4+ messages)

Message-ID: <F10BB1FAF801D111829B0060971D839F5B06DA@cpsmail>
Permalink:  ../F10BB1FAF801D111829B0060971D839F5B06DA@cpsmail/
Also on:    postgresql.org/message-id/F10BB1FAF801D111829B0060971D839F5B06DA@cpsmail

 · 

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: djackson@cpsgroup.com, gordonc@cyberbiz.net.au, sferac@bo.nettuno.it
  Subject: Re: [SQL] Probs with int2 in functions
  In-Reply-To: <F10BB1FAF801D111829B0060971D839F5B06DA@cpsmail>
  References: <F10BB1FAF801D111829B0060971D839F5B06DA@cpsmail>

* 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