| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-09-28 15:35:01 | Re: New version of money type |
| Previous Message | Luke Lonergan | 2006-09-28 15:25:45 | Re: New version of money type |