To: pgsql-sql@postgresql.org
connect(): No such file or directory
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: How to get localized to_char(DATE) output
Date: Thu, 06 May 2010 00:26:04 +0200
Lines: 36
Message-ID: <hrsr9s$6n7$1@dough.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: ppp-188-174-22-130.dynamic.mnet-online.de
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
	rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.011 tagged_above=-5 required=5
	tests=BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201005/14
X-Sequence-Number: 34062

Hi,

I'm trying to get the output of the to_char(date, text) method in German but I can't get it to work:

My understanding is, that I need to set lc_time for the session in order to change the language used by to_char(), but this does not seem to work for me:

postgres=> select version();
                            version
-------------------------------------------------------------
  PostgreSQL 8.4.3, compiled by Visual C++ build 1400, 32-bit
(1 Zeile)

postgres=> select to_char(current_date, 'Mon');
  to_char
---------
  May
(1 Zeile)

postgres=> set lc_time = 'German';
SET
postgres=> select to_char(current_date, 'Mon');
  to_char
---------
  May
(1 Zeile)

postgres=>

Postgres' messages are in German, but not the output of to_char()

After changing lc_time to 'German' I would have expected 'Mai' instead of 'May'

What am I mising?

Regards
Thomas