Re: [SQL] Procedure failing after upgrade

2004-05-05 Thread Jie Liang
PROTECTED] Subject: [SQL] Procedure failing after upgrade 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! Original Func: SELECT generateinvoice('{123,124}'); CREATE FUNCTION "generateinvoice" (inte

Re: [SQL] Procedure failing after upgrade

2004-05-05 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> 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 s

Re: [SQL] Procedure failing after upgrade

2004-05-05 Thread Rod Taylor
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 int

[SQL] Procedure failing after upgrade

2004-05-05 Thread patkins
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! Original Func: SELECT generateinvoice('{123,124}'); CREATE FUNCTION "generateinvoice" (integer[]) RETURNS integer AS ' DECLARE id_array ALIAS for $1; temp