Thread: TM modificator don't work? to_char
Hello, I try 8.2 features. I tested to_char from doc, but without success. postgres=# select to_char(now(), 'TMDay, DD TMMonth YYYY'); to_char ----------------------------- Thursday, 28 September 2006 (1 row) I expected translated names :-(. What can be wrong. lc_collate | cs_CZ.UTF-8 | Shows the collation order locale. lc_ctype | cs_CZ.UTF-8 | Shows the character classification and case conversion locale. lc_messages | cs_CZ.UTF-8 | Sets the language in which messages are displayed. lc_monetary | cs_CZ.UTF-8 | Sets the locale for formatting monetary amounts. lc_numeric | cs_CZ.UTF-8 | Sets the locale for formatting numbers. lc_time | cs_CZ.UTF-8 Regards Pavel Stehule _________________________________________________________________ Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/
Can someone confirm this features works or fails? --------------------------------------------------------------------------- Pavel Stehule wrote: > Hello, > > I try 8.2 features. I tested to_char from doc, but without success. > > postgres=# select to_char(now(), 'TMDay, DD TMMonth YYYY'); > to_char > ----------------------------- > Thursday, 28 September 2006 > (1 row) > > I expected translated names :-(. What can be wrong. > > lc_collate | cs_CZ.UTF-8 | > Shows the collation order locale. > lc_ctype | cs_CZ.UTF-8 | > Shows the character classification and case conversion locale. > lc_messages | cs_CZ.UTF-8 | > Sets the language in which messages are displayed. > lc_monetary | cs_CZ.UTF-8 | > Sets the locale for formatting monetary amounts. > lc_numeric | cs_CZ.UTF-8 | > Sets the locale for formatting numbers. > lc_time | cs_CZ.UTF-8 > > Regards > > Pavel Stehule > > _________________________________________________________________ > Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
On Mon, 2 Oct 2006, Bruce Momjian wrote: > > Can someone confirm this features works or fails? As I see from the original commit: http://groups.google.com/group/pgsql.committers/browse_frm/thread/4ba64c906fca7211/0e3b4d495ec7ecf8?lnk=gst&q=to_char&rnum=8#0e3b4d495ec7ecf8 http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/formatting.c.diff?r1=1.103&r2=1.104 the patch for to_char wasn't written at all for looking into the locale settings... It "uses" gettext() to "localize" the output of to_char() which seems to be pretty useless behaviour... Regards, Sergey ******************************************************************* Sergey E. Koposov Max Planck Institute for Astronomy/Sternberg Astronomical Institute Tel: +49-6221-528-349 Web: http://lnfm1.sai.msu.ru/~math E-mail: math@sai.msu.ru
Bruce Momjian <bruce@momjian.us> writes: > Can someone confirm this features works or fails? It works if you have NLS translations for "Thursday", "September", etc ... which none of the backend .po files do yet. regards, tom lane
Tom Lane wrote: > Bruce Momjian <bruce@momjian.us> writes: > > Can someone confirm this features works or fails? > > It works if you have NLS translations for "Thursday", "September", > etc ... which none of the backend .po files do yet. But they will when we have the po files updated for this release, I suppose. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Bruce Momjian <bruce@momjian.us> writes: > Tom Lane wrote: >> It works if you have NLS translations for "Thursday", "September", >> etc ... which none of the backend .po files do yet. > But they will when we have the po files updated for this release, I > suppose. We should probably list translation updates as one of the open items for the release. regards, tom lane
Tom Lane wrote: > Bruce Momjian <bruce@momjian.us> writes: > > Tom Lane wrote: > >> It works if you have NLS translations for "Thursday", "September", > >> etc ... which none of the backend .po files do yet. > > > But they will when we have the po files updated for this release, I > > suppose. > > We should probably list translation updates as one of the open items > for the release. Added. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +