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

Re: New version of money type

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: "Luke Lonergan" <LLonergan(at)greenplum(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: New version of money type
Date: 2006-09-28 15:32:37
Message-ID: 20060928113237.3bff089b.darcy@druid.net (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

-- 
D'Arcy J.M. Cain <darcy(at)druid(dot)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.

In response to

Responses

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2006-09-28 15:35:01
Subject: Re: New version of money type
Previous:From: Luke LonerganDate: 2006-09-28 15:25:45
Subject: Re: New version of money type

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