Re: [GENERAL] Smallint - Integer Casting Problems in Plpgsql functions

2004-03-17 Thread Denis Gasparin
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: [EMAIL PROTECTED] --- Pr

Re: [GENERAL] Smallint - Integer Casting Problems in Plpgsql functions

2004-03-17 Thread Richard Huxton
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,intege