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

From Peter Eisentraut
Subject Re: function to format floats as money?
Date
Msg-id Pine.LNX.4.30.0104171724230.762-100000@peter.localdomain
Whole thread Raw
In response to function to format floats as money?  (Mark Stosberg <mark@summersault.com>)
List pgsql-sql
Mark Stosberg writes:

>   I'm curious to know if there is a function available in Postgres 7.0.3
> (or 7.1) that will format a float style number as "money". I understand
> that the money type is going away in the future, so using a float type
> that is sometimes formatted like money seems like a good alternative. So
> ideally, I'm looking for a solution that won't go away when the money type
> does. :) Thanks!

to_char() for formatting.

numeric for storage.

Using floats for monetary amounts is not only an extremely bad idea
because of the inexactness of storage and arithmetic, it might even be
illegal if you're using it for official purposes.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Rini Dutta
Date:
Subject: drastic reduction in speed of inserts as the table grows
Next
From: "Josh Berkus"
Date:
Subject: Re: Re: Using Random Sequence as Key