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