Re: L doesn't seem to be working in to_char()

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