Re: Procedure failing after upgrade - Mailing list pgsql-sql

From Tom Lane
Subject Re: Procedure failing after upgrade
Date
Msg-id 9346.1083786367@sss.pgh.pa.us
Whole thread Raw
In response to Re: Procedure failing after upgrade  (Rod Taylor <pg@rbt.ca>)
List pgsql-sql
Rod Taylor <pg@rbt.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


pgsql-sql by date:

Previous
From: "Jie Liang"
Date:
Subject: Re: Procedure failing after upgrade
Next
From: "Andrei Bintintan"
Date:
Subject: Re: not really SQL but I need info on BLOBs