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
---------------------------(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
