On 2020-01-28 03:11, Tom Lane wrote:
The other question your example raises is whether we should be trying to de-accent before comparison, ie was it right for 'Ιανουάριος' to be treated differently from 'Ιανουαριος'. I don't know enough Greek to say, but it kind of feels like that should be outside to_date's purview.
To clarify, nothing in my examples was meant to imply that de-accenting might be necessary. AFAICT, the accented forms are the only linguistically acceptable forms and all the locale libraries accept them correctly in their accented forms.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
