Re: [HACKERS] to_char and Roman Numeral (RN) bug

On Fri, Sep 07, 2001 at 04:23:08PM -0400, Bruce Momjian wrote:
>
> I have checked this in CVS and it is working fine. Karel, have you
> fixed this? I can't find a place where I have applied a fix for this.

It is not fixed and I doubt that it is working fine in current CVS. The
bugfix is in the attached patch. Please apply it. Thanks.

Output must be:

test=# SELECT to_char(485, 'RN');
to_char
-----------------
CDLXXXV
(1 row)

test=# SELECT to_char(485, 'FMRN');
to_char
---------
CDLXXXV
(1 row)

test=# SELECT to_char(1000, 'RN');
to_char
-----------------
M
(1 row)

test=# SELECT to_char(7.2, '"Welcome to"9.9 "release! :-)"');
to_char
-----------------------------
Welcome to 7.2 release! :-)
(1 row)

Thanks to jlx(at)commandprompt(dot)com for this bug report!

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

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