Thread: Is money useless?
12-04-03, 15:54 #1Registered User
- Join Date
- Dec 2003
- Houston, Texas USA
Unanswered: Is money useless?
Just thought I'd add a catchy title. The money data type does look interesting to me, however it does seem to have it's problems. For one it does'nt seem to support very large numbers, in fact in some ways it's not treated as a number at all. While I can still use it in calculations and aggregates like sum() at al, it doesn't seem to round and there is no round(money) function available. Don't even talk about ODBC recognizing it or treating it properly.
My main concern for the time is rounding. Am I missing something is there a cast() I can apply to it? Or, perhaps I should avoid it altogether. What's your take on this situation.
12-05-03, 04:54 #2Registered User
- Join Date
- Sep 2001
I think you should avoid it
use numeric instead
There was some discussion on the hackers list some times ago
that the money datataype will be deprecated.
on the TODO list:
Remove Money type, add money formatting for decimal typehttp://www.postgresql.org
--Postgresql is the only kind of thing--