Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA59417; Sat, 6 Nov 1999 10:34:23 -0500 (EST) (envelope-from peter@peter-e.yi.org) Received: from uria.its.uu.se ([130.238.7.14]:4327 "EHLO peter-e.yi.org") by merganser.its.uu.se with ESMTP id ; Sat, 6 Nov 1999 16:34:11 +0100 Received: from peter (helo=localhost) by peter-e.yi.org with local-esmtp (Exim 3.02 #2) id 11k79H-0000Hx-00; Sat, 06 Nov 1999 15:48:59 +0100 Date: Sat, 6 Nov 1999 15:48:59 +0100 (CET) From: Peter Eisentraut To: De Moudt Walter cc: psql-general , pgsql-sql Subject: Re: [SQL] calulating with money type impossible ? In-Reply-To: <382352FB.D6779588@planetinternet.be> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Peter Eisentraut The money type is deprecated in favour of the NUMERIC(9,2) (or whatever) type. There indeed aren't a lot of functions and operators for money, and no one is going to implement them now. In fact, type money might disappear soon! -Peter On 1999-11-05, De Moudt Walter mentioned: > Hi, > > This is kind of a repost, because i didn't get any answers on it last > time :-( > > Trying to find a way to calculate with the money-type. The kind of : > > select (sales_price/transport_costs) as trans_rate from account_details; > > to get the ratio of to amounts of money. The result should be a float! > > Well, it doesn't seem possible. > In pg_proc table i found 2 procedures possibly usable for money > conversion: > cash_out(): takes one money argument, delivers a int4 > cash_in() : takes one argument (don't know what kind) and delivers a > money-type. > > Here's what i got with it : > > bookbiz=> select cash_in(20); > pqReadData() -- backend closed the channel unexpectedly. > This probably means the backend terminated abnormally > before or while processing the request. > We have lost the connection to the backend, so further processing is > impossible. Terminating. > \* so i reconnect \* > [walter@localhost walter]$ psql bookbiz > > bookbiz=> select cash_out('$25.00'); > cash_out > --------- > 136509096 > (1 row) > bookbiz=> select cash_out('$25.00'); > cash_out > --------- > 136508128 > (1 row) > bookbiz=> > (2 different results for the same argument) > So cash_in kicks me out, an cash_out just delivers nonsens. > > I'm using postgresql server version 6.5.2.1 > and client 6.5.1.2, RPM-versions on RedHat 6.0. > > Has any-one done better with money (on postgres) ? > Please let me know, if it isn't possible as well.. then i just > change my money-fields to floats > > Thanks > > De Moudt Walter. > > ************ > > -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden