Re: I want more Money (the data type, of course! :-)) - Mailing list pgsql-general

From Stephan Szabo
Subject Re: I want more Money (the data type, of course! :-))
Date
Msg-id Pine.BSF.4.21.0105221201200.63284-100000@megazone23.bigpanda.com
Whole thread Raw
In response to I want more Money (the data type, of course! :-))  (Carlos Moreno <moreno@mochima.com>)
List pgsql-general
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).


pgsql-general by date:

Previous
From: "hiroko"
Date:
Subject: vacuuuuuuum!!! Part2
Next
From: kavoos
Date:
Subject: Functional Indices