Re: function to format floats as money?

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: John Hasler <john(at)dhh(dot)gt(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: function to format floats as money?
Date: 2001-04-17 19:59:43
Message-ID: 20010417145943.B19087@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Olbersen 2001-04-17 20:29:05 Re: is this proper sql?
Previous Message Oleg Bartunov 2001-04-17 19:51:52 Re: RTREE on points