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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match