Re: to_char and i18n - Mailing list pgsql-hackers

From Manuel Sugawara
Subject Re: to_char and i18n
Date
Msg-id m33bklsrek.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Re: to_char and i18n  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses Re: to_char and i18n  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:

> Can you give a small introduction of i18n and what's your plan in
> PostgreSQL?

i18n == Internationalization (maybe I should say l10n ==
localization). This means that to_char functions might lead to
different results depending on the i18n settings. For instance,
nowadays, select to_char(now(), 'dd-mon-yy') returns 21-dec-05
regardless of the i18n settings. This should lead 21-dic-05 in the
es_MX localization. This also applies to the concurrency symbol,
thousand separator, etc.

(Some time ago I proposed an--incomplete--patch and it was rejectd by
Karel arguing that to_char functions should behave *exactly* the same
way that they do in Oracle.)

Regards,
Manuel.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: to_char and i18n
Next
From: Manuel Sugawara
Date:
Subject: Re: to_char and i18n