Re: [HACKERS] to_char and Roman Numeral (RN) bug - Mailing list pgsql-patches

From Karel Zak
Subject Re: [HACKERS] to_char and Roman Numeral (RN) bug
Date
Msg-id 20010910144846.J14578@zf.jcu.cz
Whole thread Raw
Responses Re: [HACKERS] to_char and Roman Numeral (RN) bug  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [HACKERS] to_char and Roman Numeral (RN) bug  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
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@commandprompt.com for this bug report!

        Karel

--
 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

pgsql-patches by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] CURRENT CVS: MULTIBYTE: CANT CONNECT....
Next
From: Dave Harkness
Date:
Subject: Re: [JDBC] Patch for jdbc2 ResultSet.java