X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 1C34ED1F187
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  5 May 2004 14:50:32 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 64386-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  5 May 2004 14:50:11 -0300 (ADT)
Received: from tht.net (vista.tht.net [216.126.88.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 96DA7D1E6AA
	for <pgsql-sql@postgresql.org>; Wed,  5 May 2004 14:50:10 -0300 (ADT)
Received: from [134.22.70.11] (dyn-70-11.tor.dsl.tht.net [134.22.70.11])
	by tht.net (Postfix) with ESMTP
	id 7F38176B4D; Wed,  5 May 2004 13:50:14 -0400 (EDT)
Subject: Re: Procedure failing after upgrade
From: Rod Taylor <pg@rbt.ca>
To: patkins <patkins@killinglyschools.org>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20040504133209.3EC83D1CAB0@svr1.postgresql.org>
References: <20040504133209.3EC83D1CAB0@svr1.postgresql.org>
Content-Type: text/plain
Message-Id: <1083779396.60668.10.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Wed, 05 May 2004 13:49:57 -0400
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/51
X-Sequence-Number: 17765

On Tue, 2004-05-04 at 09:32, patkins wrote:
> All,
> 
> I just upgraded to the latest version from 7.2.x and now a procedure is failing.
> 
> Please tell me what I'm doing wrong!

Please include the actual error message produced. That said, I'm getting
an interesting error. It appears as if the integer array type is being
confused for a boolean.

        WHILE id_array[count_it] LOOP

It is expecting WHILE <boolean> LOOP. Make the id_array[count_it]
expression into a boolean rather than an integer. Something like:

        WHILE id_array[count_it] IS NOT NULL LOOP