Re: rounding problems - Mailing list pgsql-general

From Justin
Subject Re: rounding problems
Date
Msg-id 4829DFA2.7040804@emproshunts.com
Whole thread Raw
In response to rounding problems  (Justin <justin@emproshunts.com>)
Responses Re: rounding problems  (Sam Mason <sam@samason.me.uk>)
Re: rounding problems  (Decibel! <decibel@decibel.org>)
List 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

pgsql-general by date:

Previous
From: Vjy
Date:
Subject: C function
Next
From: Martijn van Oosterhout
Date:
Subject: Re: change encoding