Re: Procedure failing after upgrade

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Procedure failing after upgrade
Дата
Msg-id 9346.1083786367@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Procedure failing after upgrade  (Rod Taylor <pg@rbt.ca>)
Список 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 по дате отправления:

Предыдущее
От: "Jie Liang"
Дата:
Сообщение: Re: Procedure failing after upgrade
Следующее
От: "Andrei Bintintan"
Дата:
Сообщение: Re: not really SQL but I need info on BLOBs