Received: from nexus.kearneydev.com (IDENT:root@nexus.kearneydev.com [208.136.214.2]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA22695 for ; Tue, 6 Jul 1999 14:49:27 -0400 (EDT) (envelope-from secret@kearneydev.com) Received: from kearneydev.com (atu.kearneydev.com [208.136.214.93]) by nexus.kearneydev.com (8.8.5/8.8.5) with ESMTP id OAA11032 for ; Tue, 6 Jul 1999 14:49:21 -0400 Message-ID: <37824FB0.4BD0714C@kearneydev.com> Date: Tue, 06 Jul 1999 14:49:20 -0400 From: secret Organization: Kearney Development Co., Inc. X-Mailer: Mozilla 4.51 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: PG-SQL Subject: Type Conversion: int4 -> Money Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there a way to convert an int4 into a money? I have a few reports that require format of int4 as a money(I didn't use money for money because it's very difficult to convert money into other types it seems)... The only way I can figure out how to do it is a kludge, such as: CREATE TABLE z(a int4, b money); Fill a with appropriate values, then set b as "1". SELECT a*b as a FROM z... And your done... But there should be some easier way to convert an int4 into a money rather than mulitply it? --David