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])