Postgres Pro
Downloads
Home   >   mailing lists

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

From John Hasler
Subject Re: function to format floats as money?
Date
Msg-id 87ae5ftl3z.fsf@toncho.dhh.gt.org
Whole thread Raw
In response to Re: function to format floats as money?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: function to format floats as money?  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: clayton cottingham
Date:
Subject: any proper benchmark scripts?
Next
From: clayton cottingham
Date:
Subject: is this proper sql?