Re: BUG #14138: Inconsistent rounding behavior in float4 coercion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Charles <cooper(dot)charles(dot)m(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14138: Inconsistent rounding behavior in float4 coercion
Date: 2016-05-23 17:00:08
Message-ID: 31966.1464022808@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Charles <cooper(dot)charles(dot)m(at)gmail(dot)com> writes:
> As a follow-up question, I am a bit confused as to the following behavior:
> ...
> How come 11143.1504 is not printed in all of these cases?

float4 to numeric casting doesn't honor extra_float_digits, it just
converts as many digits as will be reliable.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Charles 2016-05-23 17:05:41 Re: BUG #14138: Inconsistent rounding behavior in float4 coercion
Previous Message Francisco Olarte 2016-05-23 16:44:19 Re: BUG #14138: Inconsistent rounding behavior in float4 coercion