Re: L doesn't seem to be working in to_char() - Mailing list pgsql-general

Bill Moran wrote:
> The user guide says that L should produce the currency symbol as defined
> by the locale.  It doesn't seem to be working for me.
>
> agelis=# select to_char(1257.5, 'LFM999G999G999G999D99');
>   to_char
> ----------
>    1,257.5
> (1 row)
>
> Can anyone confirm that this is a problem, or have I made a mistake
> somewhere?  I'm running 7.4.1 on FreeBSD.

I got it working on FreeBSD 4.9.  The fix was to set lc_monetary
properly:

    template1=# set lc_monetary = 'en_US.ISO8859-1';
    SET
    template1=# select to_char(1257.5, 'LFM999G999G999G999D99');
     to_char
    ----------
     $1,257.5
    (1 row)


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