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 Bintintan||Date: 2004-05-06 05:27:20|
|Subject: Re: not really SQL but I need info on BLOBs|
|Previous:||From: Rod Taylor||Date: 2004-05-05 17:49:57|
|Subject: Re: Procedure failing after upgrade|