Re: lc_time and localized dates - Mailing list pgsql-patches

From Tom Lane
Subject Re: lc_time and localized dates
Date
Msg-id 5946.1204051636@sss.pgh.pa.us
Whole thread Raw
In response to Re: lc_time and localized dates  (Euler Taveira de Oliveira <euler@timbira.com>)
Responses Re: lc_time and localized dates  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Re: lc_time and localized dates  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-patches
Euler Taveira de Oliveira <euler@timbira.com> writes:
> FYI, strftime() [1] doesn't say anything about capitalization. I don't
> know if some translators are aware of it and even if they are, how would
> they know that a day or month is the first word of a sentence? IMHO we
> should provide Xxxxx, xxxxx, and XXXXX so the programmer can use
> whatever he/she thinks is correct for him/her.

I think you've missed the point, which is that the programmer can't
possibly know in advance which capitalization is correct, if she's
trying to build a system that works for different localizations.

But as Peter remarks nearby, this discussion is wasted anyway, because
there is only one correct answer: whatever Oracle does with these
cases is what to_char() should do.

            regards, tom lane

pgsql-patches by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: lc_time and localized dates
Next
From: "Gevik Babakhani"
Date:
Subject: Re: lc_time and localized dates