>> There'll also times a country may transit from one currency to
>> another. Even a currency (currency of most continental European
>> countries before Euro) is no more being used, it may still need to
>> be supported.
>
> The "money" type is far too simplistic to model this kind of thing. A
> really sophisticated representation of money would have to take time,
> inflation/deflation, pairwise exchange rates, etc. into account. It
> would look more like a schema with a large data set and a large body
> of code loaded into it than it would a data type.
The statement of my bank account does not contain any of the quantities you
mentioned. But when some body open a statement from year 2000, most likely
he expect to see the balance and transcations are in, say, German Marks, not
in Euros.
xz