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

Bill Moran <wmoran@potentialtech.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