From: | "Dave Cramer" <Dave(at)micro-automation(dot)net> |
---|---|
To: | "Carlos Moreno" <moreno(at)mochima(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: I want more Money (the data type, of course! :-)) |
Date: | 2001-05-22 19:20:21 |
Message-ID: | 019b01c0e2f4$3e9da3f0$0401a8c0@INSPIRON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Carlos,
We use int8 and keep everything in pennies. Works for us ;)
Dave
----- Original Message -----
From: "Carlos Moreno" <moreno(at)mochima(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Saturday, May 19, 2001 10:35 AM
Subject: [GENERAL] I want more Money (the data type, of course! :-))
>
> 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).
>
> Any suggestions?
>
> Thanks,
>
> Carlos
> --
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-05-22 19:22:59 | Re: Cant get Perl Module loaded |
Previous Message | Dave Cramer | 2001-05-22 19:13:33 | Re: Re: production java/postgresql |