Thread: 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/