Re: New version of money type - Mailing list pgsql-hackers

From Xiaofeng Zhao
Subject Re: New version of money type
Date
Msg-id BAY124-DAV16FE779A47D43A842E3C1AE5190@phx.gbl
Whole thread Raw
In response to Re: New version of money type  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: PostgreSQL 8.2beta1 w/ VALUES
Next
From: Tom Lane
Date:
Subject: Re: libedit broke in head