Re: format integer
От
Torge Kummerow
Тема
Re: format integer
Дата
Msg-id
FA8645D1-50B6-4A96-8D94-BBDF4A6BAAD1@panaccess.com
Ответ на
format integer (ml@ft-c.de)
Список
Дерево обсуждения
format integer ml@ft-c.de
Re: format integer "David G. Johnston" <david.g.johnston@gmail.com>
Re: format integer ml@ft-c.de
Re: format integer Steve Midgley <science@misuse.org>
Re: format integer Torge Kummerow <tk@panaccess.com>
Well strange requirement.
Guess you could do it with
case when x < 10 then ... else when x < 100 then ....
Don't think you'll find anything native.
--
Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.
Guess you could do it with
case when x < 10 then ... else when x < 100 then ....
Don't think you'll find anything native.
Am 24. Januar 2021 15:57:02 MEZ schrieb ml@ft-c.de:
Hello,
I need a integer format with different decimal places
The integer should have 6 diggits. (or 7 or 8)
Example (6-diggits)
input -> output
123456.789 -> 123456
1234.56789 -> 1234.56
12.3456789 -> 12.3456
but when it is more then 10^6 then
12345678.9 -> 12345678
Is there a pg function for this task?
Franz
--
Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.
В списке pgsql-sql по дате отправления
