Re: Money data type in PostgreSQL?

Oliver Elphick wrote:
>
> You should not regard amounts in different currencies as equivalent.
> You cannot add Euros to dollars and get a meaningful figure; so they
> should not be in the same column.

I plan to store amount in a column (NUMERIC) and currency id in another
(CHAR(3)). Plus another column for amount in 'standard' currency (e.g.
USD; all addition/sum will be done to this column).

> You should only use NUMERIC for money; any kind of floating point
> representation will lose detail somewhere along the line.  (I suppose
> you could use BIGINT for Japanese Yen.)

--
dave