>> I think MONEY is a great datatype, at least in theory. > > I personally find it pretty useless to be honest - especially because > the currency symbol depends on the client.
I should have been more clear: I find the underlying idea of storing a fixed-scale decimal number as a pre-scaled int8 column a good idea. But MONEY is the only standard datatype that does so, and in its current implementation it's horrible, because of all the shortcomings we both mentioned. That's why I was asking whether: 1. is there a way to remove the dollar and commas from its default input/output format; and 2. is there any other fixed-scale decimal extension type that is stored as an int8, possibly with the scale specified as part of the column definition (eg. FIXED(4)) -Tobia -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
