Use numeric with appropriate precision information.
On Sat, 19 May 2001, Carlos Moreno wrote:
>
> No, it's not spam! :-)
>
> I'm just wondering if there is a data type like Money, but with
> a (much much much) higher range -- checking the documentation,
> it would look like PG uses an int (32bits) to store the amount
> of cents -- but -21 million to +21 million is insufficient for
> accounting of a small company... :-(
>
> Float is out of the question, of course (if it is really stored
> as a float or double).
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
