Money Data Type - Mailing list pgsql-sql

From Len Morgan
Subject Money Data Type
Date
Msg-id 35757FF9.C2D22CBD@bbs.xroadstx.com
Whole thread Raw
Responses Re: [SQL] Money Data Type  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
List 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


pgsql-sql by date:

Previous
From: Byron Nikolaidis
Date:
Subject: Re: [SQL] Need ODBC driver
Next
From: coronach@datacruz.com (Mike Lemler)
Date:
Subject: desc and asc