Received: from forward.airstreamcomm.net (forward.airstreamcomm.net [64.33.128.12]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HKWvu35947 for ; Tue, 17 Apr 2001 16:32:57 -0400 (EDT) (envelope-from jghasler@win.bright.net) Received: from hasler.dhh.gt.org (elk-ras2-cs-94.dial.airstreamcomm.net [64.33.138.96]) by forward.airstreamcomm.net (8.9.3/8.9.3) with ESMTP id PAA26212 for ; Tue, 17 Apr 2001 15:32:52 -0500 (CDT) Received: from [192.168.1.3] (helo=toncho.dhh.gt.org ident=mail) by hasler.dhh.gt.org with esmtp (Exim 3.12 #1 (Debian)) id 14pc9d-00075B-00 for ; Tue, 17 Apr 2001 15:32:53 -0500 Received: from john by toncho.dhh.gt.org with local (Exim 3.12 #1 (Debian)) id 14pc8s-0001q3-00; Tue, 17 Apr 2001 15:32:06 -0500 To: pgsql-sql@postgresql.org Subject: Re: function to format floats as money? References: <3ADC61E0.93E7865D@summersault.com> <20010417124104.C17425@rice.edu> <87ae5ftl3z.fsf@toncho.dhh.gt.org> <20010417145943.B19087@rice.edu> From: John Hasler Date: 17 Apr 2001 15:32:06 -0500 In-Reply-To: "Ross J. Reedstrom"'s message of "Tue, 17 Apr 2001 14:59:43 -0500" Message-ID: <874rvntghl.fsf@toncho.dhh.gt.org> Lines: 16 User-Agent: Gnus/5.0803 (Gnus v5.8.3) Emacs/20.5 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200104/281 X-Sequence-Number: 2636 I wrote: > Floats are fine for money as long as you only add and subtract and don't > deal in amounts that won't fit in the mantissa. Ross writes: > Or you're writing software in Germany (all of the EU now?) that _might_ get > used in an offical capacity. I was referring to what actually works, not to what might or might not meet with the approval of some officialdom or other. The two seldom bear any discernible relationship. -- John Hasler john@dhh.gt.org (John Hasler) Dancing Horse Hill Elmwood, WI