Re: [PATCHES] to_char(FM9.9) bug fix

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

In response to

Responses

Browse pgsql-hackers by date

  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.

Browse pgsql-patches by date

  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