Re: plpgsql: numeric assignment to an integer variable errors out - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plpgsql: numeric assignment to an integer variable errors out
Date
Msg-id 11846.1267241236@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql: numeric assignment to an integer variable errors out  (Bruce Momjian <bruce@momjian.us>)
Responses Re: plpgsql: numeric assignment to an integer variable errors out
Re: plpgsql: numeric assignment to an integer variable errors out
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ECPG, two varchars with same name on same line
Next
From: Bruce Momjian
Date:
Subject: Re: plpgsql: numeric assignment to an integer variable errors out