Bug #864: MOD(RANDOM(),1.0) don't work in 7.3.1 - Mailing list pgsql-bugs

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