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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
