Re: to_char PL/MI fix

This patch caused the following regression failures. Is the new output
valid?

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

Karel Zak wrote:
>
>
> Peter found bug in the to_char() routine for PL/MI options. This
> patch fix it -- but this patch doesn't contains tests or docs fixes. I
> will send it later.
>
> Fixed outputs:
>
> select to_char(x, '9999.999') as x,
> to_char(x, 'S9999.999') as s,
> to_char(x, 'SG9999.999') as sg,
> to_char(x, 'MI9999.999') as mi,
> to_char(x, 'PL9999.999') as pl,
> to_char(x, 'PLMI9999.999') as plmi,
> to_char(x, '9999.999SG') as sg2,
> to_char(x, '9999.999PL') as pl2,
> to_char(x, '9999.999MI') as mi2 from num;
>
> x | s | sg | mi | pl |
> -----------+-----------+-----------+-----------+------------+
> 123.000 | +123.000 | + 123.000 | 123.000 | + 123.000 |
> -123.000 | -123.000 | - 123.000 | - 123.000 | -123.000 |
> -1231.000 | -1231.000 | -1231.000 | -1231.000 | -1231.000 |
> 1231.000 | +1231.000 | +1231.000 | 1231.000 | + 1231.000 |
> 1.900 | +1.900 | + 1.900 | 1.900 | + 1.900 |
> -1.900 | -1.900 | - 1.900 | - 1.900 | -1.900 |
> -.900 | -.900 | - .900 | - .900 | -.900 |
> .900 | +.900 | + .900 | .900 | + .900 |
> .945 | +.945 | + .945 | .945 | + .945 |
> -.945 | -.945 | - .945 | - .945 | -.945 |
> -150.945 | -150.945 | - 150.945 | - 150.945 | -150.945 |
> 150.945 | +150.945 | + 150.945 | 150.945 | + 150.945 |
>
> | plmi | sg2 | pl2 | mi2
> +------------+-----------+------------+-----------
> | + 123.000 | 123.000+ | 123.000+ | 123.000
> | - 123.000 | 123.000- | -123.000 | 123.000-
> | -1231.000 | 1231.000- | -1231.000 | 1231.000-
> | + 1231.000 | 1231.000+ | 1231.000+ | 1231.000
> | + 1.900 | 1.900+ | 1.900+ | 1.900
> | - 1.900 | 1.900- | -1.900 | 1.900-
> | - .900 | .900- | -.900 | .900-
> | + .900 | .900+ | .900+ | .900
> | + .945 | .945+ | .945+ | .945
> | - .945 | .945- | -.945 | .945-
> | - 150.945 | 150.945- | -150.945 | 150.945-
> | + 150.945 | 150.945+ | 150.945+ | 150.945
>
>
> Karel
>
>
> --
> Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
> http://home.zf.jcu.cz/~zakkr/

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

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