Re: float value is rounded - Mailing list pgsql-hackers

From David Fetter
Subject Re: float value is rounded
Date
Msg-id 20091126003204.GA13542@fetter.org
Whole thread Raw
In response to Re: float value is rounded  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Wed, Nov 25, 2009 at 07:46:11PM +0100, Pavel Stehule wrote:
> 2009/11/25 Tom Lane <tgl@sss.pgh.pa.us>:
> > Pavel Stehule <pavel.stehule@gmail.com> writes:
> >> I was surprised with rounding relative not big value. Is it
> >> correct?
> >
> > You do realize float4 has only 6 decimal digits of precision?
> >
> 
> To today I though so float4 is more practical :).

Floats have never been safe with respect to operations like =, and
won't become so.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: operator exclusion constraints
Next
From: Tom Lane
Date:
Subject: Re: Application name patch - v3