Re: rounding problems

From: Justin <justin(at)emproshunts(dot)com>
To: Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: rounding problems
Date: 2008-05-13 18:36:18
Message-ID: 4829DFA2.7040804@emproshunts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Double holds 15 places which is the highest value of precision it can
maintain before rounding occurs.

Is is limit less no, but what is?

Practically speaking taking a vale 0.000,000,000,000,001 aka
1 trillionth of anything, i view the problem solved for 98% of problems.

Does it hide? Yes, but it hides it very well. :-P

Tomasz Ostrowski wrote:
> On 2008-05-13 19:21, Justin wrote:
>
>> I change it to double problem goes away.
>
> No, it does not. It only hides it deeper. double is also a floating
> point type and has the same problems.
>
> Regards
> Tometzky

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Derek Chen-Becker 2008-05-13 19:54:15 Totally unremovable dead rows?
Previous Message Robert Treat 2008-05-13 18:23:27 Re: pg_standby / WAL archive-restore through system restarts