On Fri, Jan 24, 2020 at 5:46 PM Tom Lane <[email protected]> wrote: > Peter Eisentraut <[email protected]> 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? > > To illustrate the issue, it does not work as expected:
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
