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