-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sat, Sep 30, 2006 at 01:00:05PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> 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-----
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
