[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
