jcrada wrote:
Hi, I'm having trouble displaying date names in other locales:

central=# show lc_messages;
   lc_messages
-----------------
 fr_FR.ISO8859-1
(1 row)

central=# select to_char('2007/01/01'::date,'TMMonth');
 to_char
---------
 January
(1 row)

This result is not the expected result, since my locale is fr_FR I
expect (as older versions of psql) to return Janvier instead. The same
applies when lc_messages = 'es_VE'.
Localization support in dates using to_char(date,varchar) is gone.

Most likely, you're using a version compiled without Native Language Support support (see --enable-nls configure option).

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to