Re: Bug on parameter bigint in PL/PGSQL

From: Michele Bendazzoli <mickymouse(at)mickymouse(dot)it>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Bug on parameter bigint in PL/PGSQL
Date: 2003-08-22 14:24:27
Message-ID: 1061562092.791.69.camel@mickymouse.sintel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shridhar Daithankar 2003-08-22 15:11:25 Re: [SQL] "SELECT IN" Still Broken in 7.4b
Previous Message Richard Huxton 2003-08-22 13:05:16 Re: Bug on parameter bigint in PL/PGSQL