Received: from mail2.xroadstx.com (xroadstx.com [208.220.74.12]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA02191 for ; Wed, 3 Jun 1998 12:57:40 -0400 (EDT) Received: from bbs.xroadstx.com (mnet01-19.xroadstx.com [208.234.65.38]) by mail2.xroadstx.com (8.8.8/8.8.8) with ESMTP id LAA25982 for ; Wed, 3 Jun 1998 11:57:40 -0500 (CDT) Message-ID: <35757FF9.C2D22CBD@bbs.xroadstx.com> Date: Wed, 03 Jun 1998 11:55:21 -0500 From: Len Morgan Organization: Digital Magic, Inc. X-Mailer: Mozilla 4.02 [en]C-DIAL (Win95; U) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Money Data Type Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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