Re: cast numeric with scale and precision to numeric plain

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cast numeric with scale and precision to numeric plain
Дата
Msg-id 27206.1256050388@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: cast numeric with scale and precision to numeric plain  (Sim Zacks <sim@compulab.co.il>)
Ответы Re: cast numeric with scale and precision to numeric plain  (Sim Zacks <sim@compulab.co.il>)
Список pgsql-general
Sim Zacks <sim@compulab.co.il> writes:
>>> I'm not sure offhand what is the easiest way to suppress trailing
>>> zeroes, but casting to plain numeric is not the route to a solution.

> According to the documentation, numeric is stored without any leading
> or trailing zeros.

That says *stored*; it doesn't say *displayed*.

            regards, tom lane

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

Предыдущее
От: "Ow Mun Heng"
Дата:
Сообщение: PANIC : right sibling's left-link doesn't match
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re:答复: [GENERAL] About could not connect to server: Connection timed out