Received: from forward.airstreamcomm.net (forward.airstreamcomm.net [64.33.128.12]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HIr8u12818 for ; Tue, 17 Apr 2001 14:53:09 -0400 (EDT) (envelope-from jghasler@win.bright.net) Received: from hasler.dhh.gt.org (elk-ras1-cs-129.dial.airstreamcomm.net [64.33.137.131]) by forward.airstreamcomm.net (8.9.3/8.9.3) with ESMTP id NAA14499 for ; Tue, 17 Apr 2001 13:53:04 -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 14paax-0006nZ-00 for ; Tue, 17 Apr 2001 13:52:59 -0500 Received: from john by toncho.dhh.gt.org with local (Exim 3.12 #1 (Debian)) id 14paaG-0001nG-00; Tue, 17 Apr 2001 13:52:16 -0500 To: pgsql-sql@postgresql.org Subject: Re: function to format floats as money? References: <3ADC61E0.93E7865D@summersault.com> <20010417124104.C17425@rice.edu> From: John Hasler Date: 17 Apr 2001 13:52:16 -0500 In-Reply-To: "Ross J. Reedstrom"'s message of "Tue, 17 Apr 2001 12:41:04 -0500" Message-ID: <87ae5ftl3z.fsf@toncho.dhh.gt.org> Lines: 11 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/275 X-Sequence-Number: 2630 Ross writes: > But seriously, numeric(10,2) (or whatever precision and scale is correct > for your application) is the standard answer. 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. -- John Hasler john@dhh.gt.org (John Hasler) Dancing Horse Hill Elmwood, WI