Re: floor function in 7.3b2 - Mailing list pgsql-hackers

From Neil Conway
Subject Re: floor function in 7.3b2
Date
Msg-id 87fzvmbtqd.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: floor function in 7.3b2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses numeric hierarchy again (was Re: floor function in 7.3b2)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [GENERAL] OT: Looking to Open Source the Flash training material
Next
From: Hans-Jürgen Schönig
Date:
Subject: Threaded Sorting