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

From tomas@tuxteam.de
Subject Re: New version of money type
Date
Msg-id 20061001044139.GB11842@www.trapp.net
Whole thread Raw
In response to Re: New version of money type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, Sep 30, 2006 at 01:00:05PM -0400, Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
[...]
> Oh BTW: 10^14 is not enough dynamic range --- those guys push around
> *serious* amounts of money.  Bill Gates' net wealth is somewhere north
> of 10^13 cents, and he's just a private citizen not a bank.

I do agree that a range in the 10^14 is too small. Even 10^16 seems to
be uncomfortably near to existing values. And thensome like to do things
with (decimal) sub-cent accuracy (think percents and prices per weight
unit). May be 64 bit is just not enough for a tagged money type?

Regards
- -- tomas
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFH0cDBcgs9XrR2kYRAhBfAJ9xvi1z8N73VpoiPSczZCUgBENKrgCdHGOd
fEY52y+um4jgW1oUkb8YQ64=
=0UGx
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: libedit broke in head
Next
From: Tom Lane
Date:
Subject: Re: Still need GUC update_process_title?