On Thu, Sep 28, 2006 at 11:32:37AM -0400, D'Arcy J.M. Cain wrote:
> On Thu, 28 Sep 2006 11:25:45 -0400
> "Luke Lonergan" <LLonergan@greenplum.com> wrote:
> > Oic - so it's a floating point in an 8 byte int. That probably limits the speed benefits, no?
>
> No, it's an int type. Floating point has nothing to do with the money
> type, either in the old 32 bit version or the proposed 64 bit version.
> It does display in a DECIMAL format but just because there is a decimal
> point in the output does not make it floating point. All internal
> calculations are done as integer arithmetic.
Floating point math and hard-earned money are two things that don't mix
well. :)
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)