Thread: to_char(FM9.9) bug fix

to_char(FM9.9) bug fix

From
Karel Zak
Date:
 The patch fix bug described in TODO:

 * to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not

 NOTE! Please, first apply Neil's patch with to_char() code clean up.


 Thanks

    Karel


test=# select to_char(0,'FM9.9');
 to_char
---------
 0.
(1 row)

test=# select to_char(1,'FM9.9');
 to_char
---------
 1.
(1 row)

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Attachment

Re: to_char(FM9.9) bug fix

From
Bruce Momjian
Date:
Patch applied.  Thanks.

TODO item marked as completed.

---------------------------------------------------------------------------


Karel Zak wrote:
>
>  The patch fix bug described in TODO:
>
>  * to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not
>
>  NOTE! Please, first apply Neil's patch with to_char() code clean up.
>
>
>  Thanks
>
>     Karel
>
>
> test=# select to_char(0,'FM9.9');
>  to_char
> ---------
>  0.
> (1 row)
>
> test=# select to_char(1,'FM9.9');
>  to_char
> ---------
>  1.
> (1 row)
>
> --
>  Karel Zak  <zakkr@zf.jcu.cz>
>  http://home.zf.jcu.cz/~zakkr/
>
>  C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073