Re: New version of money type
От | tomas@tuxteam.de |
---|---|
Тема | Re: New version of money type |
Дата | |
Msg-id | 20060930082314.GA7651@www.trapp.net обсуждение исходный текст |
Ответ на | Re: New version of money type (David Fetter <david@fetter.org>) |
Список | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, Sep 29, 2006 at 10:43:53PM -0700, David Fetter wrote: > On Sat, Sep 30, 2006 at 04:42:13AM +0000, tomas@tuxteam.de wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > On Fri, Sep 29, 2006 at 12:19:07PM +0200, Martijn van Oosterhout wrote: > > > On Thu, Sep 28, 2006 at 06:32:11PM -0500, Jim C. Nasby wrote: [15 bit for three upcase ASCII] > I feel silly for even mentioning this, but there are less than 256 > countries in the UN, and as far as I know, each has at most one > currency, so you could use 8 bits instead of 15. Hm. But then you'd have to cope with a mapping (currency-id -> description) which changes over time. Maybe it'd suffice to postulate that "no id be reused". > > That leaves forty-eightish bits for the number or about 10^14. > > By the above calculation, 56 bits or about 7.2 * 10^16. Yes, way more useful than 10^14 (about a hundred times ;) > It's not just dependent on time. Exchange rates vary in such a way > that the relationships are not always transitive :P :-) Regards - -- tomas -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFFHilyBcgs9XrR2kYRAg+mAJ96+TTAjqEJK7J1nbI7EwVibYFoxwCfWElO VJCskdQThqxI90gzTX+gR8A= =OCN0 -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: