Re: New version of money type - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: New version of money type
Date
Msg-id 20060928153500.GK34238@nasby.net
Whole thread Raw
In response to Re: New version of money type  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: New version of money type  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: New version of money type
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: New version of money type