Re: [GENERAL] trouble with to_char('L') - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: [GENERAL] trouble with to_char('L')
Date
Msg-id 20100420173406.93AF.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: [GENERAL] trouble with to_char('L')  (Magnus Hagander <magnus@hagander.net>)
Responses Re: [GENERAL] trouble with to_char('L')  (Bruce Momjian <bruce@momjian.us>)
Re: [GENERAL] trouble with to_char('L')  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> wrote:

> > 1. setlocale(LC_CTYPE, lc_monetary)
> > 2. setlocale(LC_MONETARY, lc_monetary)
> > 3. lc = localeconv()
> > 4. pg_do_encoding_conversion(lc->xxx,
> >      FROM pg_get_encoding_from_locale(lc_monetary),
> >      TO GetDatabaseEncoding())
> > 5. Revert LC_CTYPE and LC_MONETARY.

A patch attached for the above straightforwardly. Does this work?
Note that #ifdef WIN32 parts in the patch are harmless on other platforms
even if they are enabled.

> Let's work off what we have now to start with at least. Bruce, can you
> comment on that thing about the extra parameter? And UTF8?

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center


Attachment

pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: row estimation off the mark when generate_series calls are involved
Next
From: Fujii Masao
Date:
Subject: Re: [DOCS] Streaming replication document improvements