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