Re: New version of money type
От | Xiaofeng Zhao |
---|---|
Тема | Re: New version of money type |
Дата | |
Msg-id | BAY124-DAV16FE779A47D43A842E3C1AE5190@phx.gbl обсуждение исходный текст |
Ответ на | Re: New version of money type (Martijn van Oosterhout <kleptog@svana.org>) |
Список | pgsql-hackers |
>> 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
В списке pgsql-hackers по дате отправления: