Suppress decimal point like digits in to_char?
Hi. Is there a way with to_char to suppress a decimal point, like a leading or trailing 0, so that integers will not have them, but non-ints will? I'm hoping I'm missing something easy. Thanks.
Ken
( SELECT 1 AS val UNION SELECT 1.05 AS val) foo;
--
val | to_char
------+---------
1 | 1.
1.05 | 1.05
AGENCY Software
A Free Software data system
By and for non-profits
(253) 245-3801
learn more about AGENCY or
follow the discussion.
В списке pgsql-general по дате отправления: