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

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Carlos Moreno <moreno(at)mochima(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I want more Money (the data type, of course! :-))
Date: 2001-05-22 19:04:42
Message-ID: Pine.BSF.4.21.0105221201200.63284-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2001-05-22 19:13:33 Re: Re: production java/postgresql
Previous Message Tomasz Wegrzanowski 2001-05-22 18:41:45 Re: postgreSQL 7.0.3 + kdevelop 1.4.1