Re: floating point output

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: floating point output
Дата
Msg-id EB5A6A4C-F58A-4055-82F4-1E76CD675B4C@gmail.com
обсуждение исходный текст
Ответ на Re: floating point output  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: floating point output
Список pgsql-general

> On Sep 4, 2019, at 9:14 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
>> On 9/4/19 5:23 PM, Rob Sargent wrote:
>> I've found the description of floating point types (here
<https://www.postgresql.org/docs/10/datatype-numeric.html#DATATYPE-FLOAT>),but I'm looking for the rationale of the
outputformat, particularly with respect to total digits presented (variable in a single select's output) and the
droppingof a trailing zero (to some implying a loss of precision).  Is the code my only guide here? 
>
> Some examples would help explain your concerns.
>
> Bottom line, if you want precision use numeric.
>
>
>
When at my desk I’ll give example. Actual precision is not the issue. Purely cosmetics.


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

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Rebuild pg_toast from scratch?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Rebuild pg_toast from scratch?