Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3HK00u28637 for ; Tue, 17 Apr 2001 16:00:00 -0400 (EDT) (envelope-from reedstrm@rice.edu) Received: by rice.edu via sendmail from stdin id (Debian Smail3.2.0.102) for pgsql-sql@postgresql.org; Tue, 17 Apr 2001 14:59:43 -0500 (CDT) Date: Tue, 17 Apr 2001 14:59:43 -0500 From: "Ross J. Reedstrom" To: John Hasler Cc: pgsql-sql@postgresql.org Subject: Re: function to format floats as money? Message-ID: <20010417145943.B19087@rice.edu> Mail-Followup-To: John Hasler , pgsql-sql@postgresql.org References: <3ADC61E0.93E7865D@summersault.com> <20010417124104.C17425@rice.edu> <87ae5ftl3z.fsf@toncho.dhh.gt.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0i In-Reply-To: <87ae5ftl3z.fsf@toncho.dhh.gt.org>; from john@dhh.gt.org on Tue, Apr 17, 2001 at 01:52:16PM -0500 X-Archive-Number: 200104/278 X-Sequence-Number: 2633 On Tue, Apr 17, 2001 at 01:52:16PM -0500, John Hasler wrote: > 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. Or you're writing software in Germany (all of the EU now?) that _might_ get used in an offical capacity. Ross