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

Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> Looking through the patch quickly, if you want to get Unicode-fancy,
> doing a case-insensitive comparison by running lower-case on both
> strings is also wrong in corner cases.  All the Greek month names end in
> sigma, so I suspect that this patch might not work correctly in such cases.

Hm.  That's basically what citext does, and I don't recall hearing
complaints about that.  What other definition of "case insensitive"
would you suggest?

postgres=# select lower(to_char(now(),'TMMONTH'));
   lower
------------
 ιανουάριοσ
(1 row)

postgres=# select to_char(now(),'TMmonth');
  to_char
------------
 ιανουάριος
(1 row)

Regards,

Juan José Santamaría Flecha