Bug #864: MOD(RANDOM(),1.0) don't work in 7.3.1
Sverre H. Huseby (shh@thathost.com) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
MOD(RANDOM(),1.0) don't work in 7.3.1
Long Description
I just upgraded from 7.2.3 to 7.3.1. Something has changed, as one of my old queries no longer works:
SELECT MOD(RANDOM(),1.0);
ERROR: Function mod(double precision, numeric) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
I was able to work around it by casting RANDOM() to NUMERIC.
Sample Code
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
SELECT MOD(RANDOM(),1.0);
ERROR: Function mod(double precision, numeric) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
I was able to work around it by casting RANDOM() to NUMERIC.
This is not a bug, but an intentional change: float->numeric isn't an
implicit cast anymore.
regards, tom lane
[Tom Lane]
| This is not a bug, but an intentional change: float->numeric isn't
| an implicit cast anymore.
Ah. I didn't find it in the "Observe the following incompatibilities"
of the HISTORY file, so I imagined it could be unintentional.
Thanks for replying!
Sverre.
--
shh@thathost.com Computer Geek? Try my Nerd Quiz
http://shh.thathost.com/ http://nerdquiz.thathost.com/