Subject: Re: Bug on parameter bigint in PL/PGSQL
From: Michele Bendazzoli <mickymouse@mickymouse.it>
To: pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <200308221405.16739.dev@archonet.com>
References: <1061553594.781.34.camel@mickymouse.sintel>
	<200308221405.16739.dev@archonet.com>
Content-Type: text/plain
Organization: Micky Mouse
Message-Id: <1061562092.791.69.camel@mickymouse.sintel>
Mime-Version: 1.0
Date: Fri, 22 Aug 2003 16:24:27 +0200
Content-Transfer-Encoding: 7bit

On Fri, 2003-08-22 at 15:05, Richard Huxton wrote:
> On Friday 22 August 2003 12:59, Michele Bendazzoli wrote:
> > I think i found a bug in PL/PGSQL: when i use a parameter bigint (int8)
> > and call the function from psql an error message which says that "the
> > functioname(bigint) doesn't exist" is displayed.
> > If i turn the int8 to int4 all works fine ...
> 
> Seems ok here:

cut

> Can you provide an actual example?

I delete the example because i don't need it anymore (it was a function
that simply get a int8 and return the last 4 byte (a int4), but now i
don't use int8 anymore) and the one I try to reproduce now just works
fine ...

Maybe it was only my mistake due to the overload capacity of PL/PGSQL: i
wonder if I was testing the errate version of the function while i was
modifying another: the power of postgresql :-)

Thank anyway.

ciao, Michele