Skip site navigation (1) Skip section navigation (2)

Re: New version of money type

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 (view raw or flat)
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)

In response to

Responses

pgsql-hackers by date

Next:From: D'Arcy J.M. CainDate: 2006-09-28 15:43:08
Subject: Re: New version of money type
Previous:From: D'Arcy J.M. CainDate: 2006-09-28 15:32:37
Subject: Re: New version of money type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group