Re: Smallint - Integer Casting Problems in Plpgsql functions

Hi Richard.
Thank you for your reply. I rewrote the store procedure to accept
integer instead of smallint.

What i don't understand is  why the casting is working in 7.2.3. What
has been changed from that?

Thank you,

--
Doct. Eng. Denis Gasparin: denis@edistar.com
---------------------------
Programmer & System Administrator - Edistar srl



Richard Huxton wrote:

>On Wednesday 17 March 2004 15:54, Denis Gasparin wrote:
>
>
>>Hi, i'm upgrading our database from postgresql 7.2.3 to 7.4.2.
>>The import went fine but i have some casting problems with plpgsql
>>functions.
>>
>>I've create a test function with this code:
>>
>>create function test(varchar,smallint,integer) returns integer as '
>>
>>
>
>
>
>>select test('aaa',1,1);
>>gives me the following error:
>>ERROR:  function test("unknown", integer, integer) does not exist
>>
>>
>
>Easiest solution is to just define the function as accepting integer rather
>than smallint.
>I believe the typeing will be smarter in 7.5 but don't know if it will affect
>this situation.
>
>
>