3 ms·
They do. The problem is that equality is still strict binary equality for text, for obscure technical reasons. So, while you can get extremely flexible customiz
by petergeoghegan 9y ago
They do. The problem is that equality is still strict binary equality for text, for obscure technical reasons. So, while you can get extremely flexible customizations to collation with icu [1], you can't have case insensitive equality, or equality that ignores accents. This is recognized as a problem, and is probably going to be fixed in v11.
[1] https://www.postgresql.org/message-id/CAH2-Wz=bcgmk97YaZ3rs4OoCdn1nOco1HCfRGBCOOty0ztnCnA@mail.gmail.com https://www.postgresql.org/message-id/CAH2-Wz=bcgmk97YaZ3rs4...
- anarazel 9y ago> The problem is that equality is still strict binary equality for text, for obscure technical reasons AKA performance.