Money Data Type

Len Morgan <len-morgan@xroadstx.com>

From: Len Morgan <len-morgan@xroadstx.com>
To: pgsql-sql@postgresql.org
Date: 1998-06-03T16:55:21Z
Lists: pgsql-sql
I am having a problem converting a data type of money to type float.
After 'greping' all the documentation directorys, I can't find a
reference to
"money", "Money", or "MONEY" but I know it's in there somewhere because
I have a money type (a mistake I now realize) in my database.

How do I convert from type money to type float and back?

float4(moneyfield) gives me a huge number (something e+09).  I get
similar
results with float8, float, and even int4().

Thanks in advance.

Len Morgan