float value is rounded

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?

regards, tom lane

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 :).

I am smarter now
Pavel

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