Re: Bug on parameter bigint in PL/PGSQL - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Bug on parameter bigint in PL/PGSQL
Date
Msg-id 20030822055848.F83860-100000@megazone.bigpanda.com
Whole thread Raw
In response to Bug on parameter bigint in PL/PGSQL  (Michele Bendazzoli <mickymouse@mickymouse.it>)
List pgsql-sql
On Fri, 22 Aug 2003, 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 ...

I can't reproduce from the information above.  Integer constants are
treated as int4, but it should be able to cast that to bigint.  What is
the function you are using to test and what version?



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: date calculation
Next
From: Richard Huxton
Date:
Subject: Re: Bug on parameter bigint in PL/PGSQL