From: Richard Huxton <dev@archonet.com>
To: Michele Bendazzoli <mickymouse@mickymouse.it>,
	pgsql <pgsql-sql@postgresql.org>
Subject: Re: Bug on parameter bigint in PL/PGSQL
Date: Fri, 22 Aug 2003 14:05:16 +0100
User-Agent: KMail/1.5
References: <1061553594.781.34.camel@mickymouse.sintel>
In-Reply-To: <1061553594.781.34.camel@mickymouse.sintel>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200308221405.16739.dev@archonet.com>

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:

CREATE FUNCTION my_bigint_test(int8) RETURNS int8 AS '
BEGIN
  RETURN $1 + 1::int8;
END;
' LANGUAGE 'plpgsql';

SELECT my_bigint_test(1);

CREATE FUNCTION
 my_bigint_test
----------------
              2
(1 row)

SELECT my_bigint_test(2::int8);
 my_bigint_test
----------------
              3
(1 row)

Can you provide an actual example?

-- 
  Richard Huxton
  Archonet Ltd