| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, rsmogura(at)softperience(dot)pl, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Application user name attribute on connection pool |
| Date: | 2010-08-03 06:01:34 |
| Message-ID: | 81D2B4F0-53A6-46B9-B63D-21DCD09CC7CF@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2 Aug 2010, at 23:43, Radosław Smogura wrote:
>> PostgreSQL already has BIGINT aka INT8, which are 8 bytes, and can
>> represent integers up to like 9 billion billion (eg, 9 * 10^18).
> But I think about numbers with precision - you can use float for moneys, etc
> (rounding problems), and dividing each value in application by some scale
> isn't nice, too.
Most people don't use float for monetary values.
Have a look at the NUMERIC type: http://www.postgresql.org/docs/8.4/interactive/datatype-numeric.html
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4c57b0dc286217280628589!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | quickinfo quickinfo | 2010-08-03 06:39:43 | pg_hba.conf |
| Previous Message | John R Pierce | 2010-08-02 23:10:42 | Re: Postgresql database for distributed transactions |