Re: to_char PL/MI fix - Mailing list pgsql-patches

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

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


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@zf.jcu.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@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