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

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

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: New version of money type
Next
From: "Jim C. Nasby"
Date:
Subject: Re: New version of money type