float value is rounded

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: float value is rounded
Date: 2009-11-25 18:21:06
Message-ID: 162867790911251021w497da616r53b0a46002249117@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

I was surprised with rounding relative not big value. Is it correct?

postgres=# select 499188.546875::real;
float4
────────
499189
(1 row)

regards

Pavel Stehule

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-11-25 18:34:53 Re: [PATCH 4/4] Add tests to dblink covering use of COPY TO FUNCTION
Previous Message Kevin Grittner 2009-11-25 17:43:43 Re: tsearch parser inefficiency if text includes urls or emails - new version