Skip site navigation (1) Skip section navigation (2)

Re: Procedure failing after upgrade

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: patkins <patkins(at)killinglyschools(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Procedure failing after upgrade
Date: 2004-05-05 19:46:07
Message-ID: 9346.1083786367@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
Rod Taylor <pg(at)rbt(dot)ca> writes:
> an interesting error. It appears as if the integer array type is being
> confused for a boolean.

Up till 7.4, plpgsql's control statements didn't actually check whether
the given expression returned boolean :-(.  They just assumed that the
resulting Datum should be interpreted as a bool.  7.4 will coerce to
bool or throw an error if it can't.

			regards, tom lane

In response to

pgsql-sql by date

Next:From: Andrei BintintanDate: 2004-05-06 05:27:20
Subject: Re: not really SQL but I need info on BLOBs
Previous:From: Rod TaylorDate: 2004-05-05 17:49:57
Subject: Re: Procedure failing after upgrade

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group