Tom Lane <tgl@sss.pgh.pa.us> writes:
> "Mario Weilguni" <mario.weilguni@icomedias.com> 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 <neilc@samurai.com> || PGP Key ID: DB3C29FC