Thread: Problems with localization

Hi everybody.

It's my first message, I hope I'm in the right ml.
I'm using postgresql 7.4.6 on gentoo 2004.2.
I've set nls use flag in make.conf.
I want to set locale to it_IT so that when I issue "select to_char(some_date,
'Day') from some_table" I see for example "Lunedì" instead of "Monday" ("Lunedì"
is the italian translation for "Monday")...
I think in part it works, because I see the psql initial message in italian, but
I continue to see "Monday" instead of "Lunedì"...
Any help would be appreciated.

Thank you.

Kamal




____________________________________________________________
6X velocizzare la tua navigazione a 56k? 6X Web Accelerator di Libero!
Scaricalo su INTERNET GRATIS 6X http://www.libero.it

On Sun, Jan 23, 2005 at 11:08:24PM +0100, kamal wrote:

Hi,

> I want to set locale to it_IT so that when I issue "select to_char(some_date,
> 'Day') from some_table" I see for example "Lunedì" instead of "Monday" ("Lunedì"
> is the italian translation for "Monday")...

I don't think to_char() knows about i18n/l10n yet.  So you'd need to
patch it, or convince somebody to do it for you.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El que vive para el futuro es un iluso, y el que vive para el pasado,
un imbécil" (Luis Adler, "Los tripulantes de la noche")

> I don't think to_char() knows about i18n/l10n yet.  So you'd need to
> patch it, or convince somebody to do it for you.

Ah, ok, I see. I can't do it. I think I'll write it in PL/pgSQL.
Thank you very much.

Kamal




____________________________________________________________
6X velocizzare la tua navigazione a 56k? 6X Web Accelerator di Libero!
Scaricalo su INTERNET GRATIS 6X http://www.libero.it