X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A0B3AD1B4E2 for ; Fri, 22 Aug 2003 10:00:40 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 24592-05 for ; Fri, 22 Aug 2003 10:00:13 -0300 (ADT) Received: from megazone.bigpanda.com (45.mufb.snfc.sffca01r18.dsl.att.net [12.103.249.45]) by svr1.postgresql.org (Postfix) with ESMTP id 2B63FD1D115 for ; Fri, 22 Aug 2003 10:00:06 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 8780BD658; Fri, 22 Aug 2003 06:00:08 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 751615C0E; Fri, 22 Aug 2003 06:00:08 -0700 (PDT) Date: Fri, 22 Aug 2003 06:00:08 -0700 (PDT) From: Stephan Szabo To: Michele Bendazzoli Cc: pgsql Subject: Re: Bug on parameter bigint in PL/PGSQL In-Reply-To: <1061553594.781.34.camel@mickymouse.sintel> Message-ID: <20030822055848.F83860-100000@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/274 X-Sequence-Number: 14890 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?