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

Поиск
Список
Период
Сортировка
От Charles
Тема Re: BUG #14138: Inconsistent rounding behavior in float4 coercion
Дата
Msg-id CADBa3waX4s-B1WNe4r5tdRW7m-MbJaf1TKyU+ud4fStJCrxZOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14138: Inconsistent rounding behavior in float4 coercion  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I see, so the overriding, default rule in all these cases is, "convert as
many digits as will be reliable" -- as opposed to, "convert as many digits
as are needed to do a full round-trip"?

Best,
Charles

On Mon, May 23, 2016 at 10:00 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Charles <cooper.charles.m@gmail.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
>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14138: Inconsistent rounding behavior in float4 coercion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14147: Restore of MatView of Foreign Data Table fails