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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: L doesn't seem to be working in to_char()
Date: 2004-03-16 19:40:53
Message-ID: 26892.1079466053@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> 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.

Are you sure your locale defines one? AFAICT, C locale doesn't. The
to_char code seems to fall back to using a blank if there's no currency
symbol available from localeconv().

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2004-03-16 19:41:42 Re: Network Connection
Previous Message Bill Moran 2004-03-16 19:38:48 Re: Network Connection