Ok, I've been using Postgres for quite some time now (about 6
years-ish), except for a MySQL period b/c of work requirements.
However, I never managed to use some of the more special types in the
DBMS, like 'money'.
I know that the 'money' type is now deprecated, but I wonder why it is,
and also ... how was it supposed to cast any other data type to 'money'
anyway??? I checked the function list, per \df and couldn't find any
function to do so, even though the money data type is basically an int4
with the decimal point moved two places to the left. So....
- Why did they deprecate it?
and
- Why were there no functions to convert data types *to* money? There
were plenty of possible casts *from* money...
