Am 23.07.2011 03:10, schrieb Bernd Plagge:
First, in Rich's case we don't have any information about the discrepancy amount. If it were a rounding issue the discrepancy can only be a few cents - more likely just 1 cent +/-. Bigger discrepancy can't be explained this way.
That's correct, by changing the data type we could only solve problems like this one when (33.03 + 0.02) and 33.05 are not equal.
Secondly, using numeric(8,2) instead of floating point will not work for currencies without decimals.
We would use numeric without defined precision. http://www.postgresql.org/docs/8.4/static/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL Regards Rolf _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
