Re: lc_time and localized dates

Bruce Momjian wrote:

> Euler, have you updated this patch yet?
>
Here is an updated patch. It follows the Oracle behaviour and uses a
cache mechanism to avoid calling setlocale() all the time. I unified the
localized_* and str_* functions. I didn't test it on Windows. I would
appreciate some feedback.

euler=# select to_char(now(), 'dy tmDy tmDay mon tmMON tmmonth YYYY');
to_char
-----------------------------------
thu Qui Quinta apr ABR abril 2008
(1 registro)

euler=# set lc_time to 'it_IT.UTF-8';
SET
euler=# select to_char(now(), 'dy tmDy tmDay mon tmMON tmmonth YYYY');
to_char
-------------------------------------
thu Gio Giovedì apr APR aprile 2008
(1 registro)

euler=# set lc_time to 'es_ES.UTF-8';
SET
euler=# select to_char(now(), 'dy tmDy tmDay mon tmMON tmmonth YYYY');
to_char
-----------------------------------
thu Jue Jueves apr ABR abril 2008
(1 registro)

euler=# set lc_time to 'fr_FR.UTF-8';
SET
euler=# select to_char(now(), 'dy tmDy tmDay mon tmMON tmmonth YYYY');
to_char
----------------------------------
thu Jeu Jeudi apr AVR avril 2008
(1 registro)

euler=# set lc_time to 'cs_CZ.UTF-8';
SET
euler=# select to_char(now(), 'dy tmDy tmDay mon tmMON tmmonth YYYY');
to_char
-----------------------------------
thu Čt Čtvrtek apr DUB duben 2008
(1 registro)

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