Re: plpgsql: numeric assignment to an integer variable errors out

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql: numeric assignment to an integer variable errors out
Дата
Msg-id 11846.1267241236@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql: numeric assignment to an integer variable errors out  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: plpgsql: numeric assignment to an integer variable errors out  (Bruce Momjian <bruce@momjian.us>)
Re: plpgsql: numeric assignment to an integer variable errors out  (Nikhil Sontakke <nikhil.sontakke@enterprisedb.com>)
Список pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Whatever happened to this patch?

I think we bounced it on the grounds that it would represent a
fundamental change in plpgsql behavior and break a whole lot of
applications.  People have been relying on plpgsql's coerce-via-IO
assignment behavior for ten years.  If you prefer coerce via
cast conversion, you can get that by writing an explicit cast.

Now it is true that a lot of the uses for that were subsumed when
we added coerce-via-IO to the native cast capabilities; but I'm
still quite scared of what this would break, and I don't see any
field demand for a change.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: ECPG, two varchars with same name on same line
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: plpgsql: numeric assignment to an integer variable errors out