[BUGS] Bug #864: MOD(RANDOM(),1.0) don't work in 7.3.1
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])
Re: [BUGS] More SSL patches
Has anyone looked at these yet? --Nate ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [BUGS] Bug #864: MOD(RANDOM(),1.0) don't work in 7.3.1
[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
Re: [BUGS] More SSL patches
My fault. I am running behind because of some IPv6 patch work, and the holidays. I will look at them tomorrow. --- Nathan Mueller wrote: > Has anyone looked at these yet? > > --Nate > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(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
