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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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