pribram pribram wrote:
> postgres=# SET lc_messages=cs;select to_char('2006/01/01'::timestamp, 'TMMonth');
> SET
> to_char
> ---------
> January
Hmm, it works fine for me (not Windows though):
alvherre=# SET lc_messages='C';select to_char('2006/01/01'::timestamp, 'TMMonth');
SET
to_char
---------
January
(1 fila)
alvherre=# SET lc_messages='fr_CA';select to_char('2006/01/01'::timestamp, 'TMMonth');
SET
to_char
---------
Janvier
(1 fila)
alvherre=# RESET lc_messages; select to_char('2006/01/01'::timestamp, 'TMMonth');
RESET
to_char
---------
Enero
(1 fila)
alvherre=# select version();
version
------------------------------------------------------------------------------------------
PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.3.3-3) 4.3.3
(1 fila)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.