Re: Bug on parameter bigint in PL/PGSQL

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Michele Bendazzoli <mickymouse(at)mickymouse(dot)it>
Cc: pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Bug on parameter bigint in PL/PGSQL
Date: 2003-08-22 13:00:08
Message-ID: 20030822055848.F83860-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bertrand Petit 2003-08-22 13:04:12 Re: "SELECT IN" Still Broken in 7.4b
Previous Message Tom Lane 2003-08-22 12:56:50 Re: date calculation