Re: function to format floats as money?

From: John Hasler <john(at)dhh(dot)gt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: function to format floats as money?
Date: 2001-04-17 18:52:16
Message-ID: 87ae5ftl3z.fsf@toncho.dhh.gt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)dhh(dot)gt(dot)org (John Hasler)
Dancing Horse Hill
Elmwood, WI

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message clayton cottingham 2001-04-17 19:51:16 is this proper sql?
Previous Message clayton cottingham 2001-04-17 18:38:15 any proper benchmark scripts?