Re: Allow to_date() and to_timestamp() to accept localized names - Mailing list pgsql-hackers

From Juan José Santamaría Flecha
Subject Re: Allow to_date() and to_timestamp() to accept localized names
Date
Msg-id CAC+AXB2uTOaPQ2cxvjgcGF3kRVCucftFwchZdQ5n_F0R+P7KwA@mail.gmail.com
Whole thread Raw
In response to Re: Allow to_date() and to_timestamp() to accept localized names  (Mark Dilger <mark.dilger@enterprisedb.com>)
Responses Re: Allow to_date() and to_timestamp() to accept localized names  (Mark Dilger <mark.dilger@enterprisedb.com>)
Re: Allow to_date() and to_timestamp() to accept localized names  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers


On Tue, Jan 28, 2020 at 4:06 PM Mark Dilger <mark.dilger@enterprisedb.com> wrote:

I’m not insisting, just asking about the design.  If it only works with one name supported per weekday per language, and per month per language, I’m not going to object.  I was just curious if you were going to support multiple names anyway, and if that made the question about the Greek case folding less pressing.


This patch targets to do something symmetrical to to_char(), which will just return a single value.

The issue with the greek locale is that it cannot hold this equivalent behaviour, as in:

postgres=# select to_date(to_char(now(), 'TMMONTH'), 'TMMONTH');
ERROR:  invalid value "ΙΑΝΟΥΆΡΙΟΣ" for "MONTH"

Because of the particular behaviour sigma (Σσς) casing has, which is also user visible with a lower().
 

>      %E* %O*
>            POSIX locale extensions.  The sequences %Ec %EC %Ex %EX %Ey %EY %Od %Oe %OH %OI %Om %OM %OS %Ou %OU %OV %Ow %OW %Oy are supposed to provide alternate representations.
>
>            Additionally %OB implemented to represent alternative months names (used standalone, without day mentioned).

This is the part I haven’t played with, but it sounds like it can handle at least one alternate name.  Perhaps you can get the alternates this way?


This looks like a POSIX feature that some systems might not like (Windows [1]). But if this is something that the patch should aim to, I am fine with a RWF and give it another try in the future.


Regards,

Juan José Santamaría Flecha 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is custom MemoryContext prohibited?
Next
From: Tomas Vondra
Date:
Subject: Re: Is custom MemoryContext prohibited?