On 2020-01-28 16:47, Juan José Santamaría Flecha wrote: > This patch targets to do something symmetrical to to_char(), which will > just return a single value.
I didn't fully realize while reading this thread that to_char() already supports localized output and this patch indeed just wants to do the opposite.
So I'm withdrawing my concerns with respect to this patch. As long as it can do a roundtrip conversion with to_char(), it's fine.
We can avoid issues with non injective case conversion languages with a double conversion, so both strings in the comparison end up in the same state.
I propose an upper/lower conversion as in the attached patch.