Sverre H. Huseby ([EMAIL PROTECTED]) 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to