Re: Procedure failing after upgrade

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Procedure failing after upgrade
Дата
Msg-id 1083779396.60668.10.camel@jester
обсуждение исходный текст
Ответ на Procedure failing after upgrade  ("patkins" <patkins@killinglyschools.org>)
Ответы Re: Procedure failing after upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
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 integer array type is being
confused for a boolean.
       WHILE id_array[count_it] LOOP

It is expecting WHILE <boolean> LOOP. Make the id_array[count_it]
expression into a boolean rather than an integer. Something like:
       WHILE id_array[count_it] IS NOT NULL LOOP




В списке pgsql-sql по дате отправления:

Предыдущее
От: "patkins"
Дата:
Сообщение: Procedure failing after upgrade
Следующее
От: "Jie Liang"
Дата:
Сообщение: Re: Procedure failing after upgrade