Re: TODO item:Allow to_date() and to_timestamp() accept localized month names

"Gevik Babakhani" <pgdev(at)xs4all(dot)nl> writes:
>> Surely it should be the inverse of the solution for output,
>> eg TMMon selects localized input.

> Of cource. But how would TM enforce a localized formatting. (perhaps I am
> off.... 2:10 am...)
> Lets say I have en_US database but the dates I am trying to format is nl_NL.
> If I am not mistaking SET LC_MESSAGES won't help.

Works for me:

postgres=# show lc_messages ;
lc_messages
-------------
de_DE.utf8
(1 row)

postgres=# select to_char(now(), 'TMDay, DD TMMonth YYYY');
to_char
-------------------------
Montag, 04 Februar 2008
(1 row)

postgres=# set lc_messages TO 'es_ES.utf8';
SET
postgres=# select to_char(now(), 'TMDay, DD TMMonth YYYY');
to_char
------------------------
Lunes, 04 Febrero 2008
(1 row)

regards, tom lane