From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] to_char(FM9.9) bug fix |
Date: | 2002-09-20 19:24:00 |
Message-ID: | Pine.LNX.4.44.0209202058240.1149-100000@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Karel Zak writes:
> test=# select to_char(0,'FM9.9');
> to_char
> ---------
> 0.
> (1 row)
>
> test=# select to_char(1,'FM9.9');
> to_char
> ---------
> 1.
> (1 row)
I find this highly bizzare. The FM modifier means to omit unnecessary
trailing stuff. There is no reasonable business or scientific custom to
leave a trailing point after a number.
Or perhaps a more pragmatic question is, how would I print a number
without the trailing point?
--
Peter Eisentraut peter_e(at)gmx(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2002-09-20 19:26:01 | [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic, SQLProcedureColumns] |
Previous Message | Kris Jurka | 2002-09-20 18:45:46 | Re: Optimizer generates bad plans. |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-09-20 20:37:12 | Re: DROP COLUMN misbehaviour with multiple inheritance |
Previous Message | Neil Conway | 2002-09-20 19:06:43 | fix for buglet |