Re: lc_time and localized dates - Mailing list pgsql-patches

From Euler Taveira de Oliveira
Subject Re: lc_time and localized dates
Date
Msg-id 47C34A98.7050102@timbira.com
Whole thread Raw
In response to Re: lc_time and localized dates  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: lc_time and localized dates  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-patches
Zdenek Kotala wrote:

> Please, Day names does not have capitalized first letter in Czech
> language. We have "pondeli" as a Monday. If locale does not do that it
> is probably intention :-).
>
Hmmm... I don't know about that. I do it that way 'cause I'm concerned
about some locales that don't capitalize (see above). In my head,
(i) 'TMMonth' is February, Fevereiro, Febrero, Únor;
(ii) 'TMmonth' is february, fevereiro, febrero, únor;
(iii) 'TMMONTH' is FEBRUARY, FEVEREIRO, FEBRERO, ÚNOR.

How would we handle that case? Is it wrong to write "Únor"?

euler=# set lc_time to 'cs_CZ';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
        to_char
---------------------
  Pondìlí Po úno únor
(1 registro)

euler=# set lc_time to 'es_ES';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
         to_char
-----------------------
  lunes lun feb febrero
(1 registro)

euler=# set lc_time to 'fr_FR';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
         to_char
-----------------------
  lundi lun fév février
(1 registro)

euler=# set lc_time to 'it_IT';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
          to_char
-------------------------
  lunedì lun feb febbraio
(1 registro)

euler=# set lc_time to 'hu_HU';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
        to_char
----------------------
  hétfõ h febr február
(1 registro)


--
   Euler Taveira de Oliveira
   http://www.timbira.com/

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: SRF memory leaks
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Fix pgstatindex using for large indexes