From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
---|---|
To: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
Cc: | Luke Lonergan <LLonergan(at)greenplum(dot)com>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: New version of money type |
Date: | 2006-09-28 15:35:01 |
Message-ID: | 20060928153500.GK34238@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)greenplum(dot)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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 2006-09-28 15:43:08 | Re: New version of money type |
Previous Message | D'Arcy J.M. Cain | 2006-09-28 15:32:37 | Re: New version of money type |