Tom Lane <[EMAIL PROTECTED]> writes: > "Mario Weilguni" <[EMAIL PROTECTED]> writes: > > Why is floor not working anymore? > > Mph. Seems we have floor(numeric) but not floor(float8), and the latter > is what you need here.
Sorry, I missed much of the casting discussion -- but is there a reason why we can't cast from float8 -> numeric implicitely? IIRC the idea was to allow implicit casts from lower precision types to higher precision ones. Cheers, Neil -- Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])