From: | Gordon Clarke <gordonc(at)cyberbiz(dot)net(dot)au> |
---|---|
To: | sferac(at)bo(dot)nettuno(dot)it |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] Probs with int2 in functions |
Date: | 1999-01-03 06:02:35 |
Message-ID: | Pine.LNX.3.96.990103145848.649B-100000@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Ari Jolma | 1999-01-04 07:10:19 | backend dies when trying a certain kind of a join |
Previous Message | Engard Ferenc | 1999-01-03 00:30:34 | c language function |