Re: function to format floats as money? - Mailing list pgsql-sql

From Ross J. Reedstrom
Subject Re: function to format floats as money?
Date
Msg-id 20010417145943.B19087@rice.edu
Whole thread Raw
In response to Re: function to format floats as money?  (John Hasler <john@dhh.gt.org>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: RTREE on points
Next
From: Stephan Szabo
Date:
Subject: Re: is this proper sql?