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

Bruce Momjian wrote:
> 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)

Yup, that's fixes it for me as well.  I'm guessing the reason this
works is contained in Tom's reply about the default 'C' locale not
having a monetary designator.

Thanks, Bruce.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com