Hacker News new | ask | show | jobs
by petergeoghegan 3232 days 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=bcgmk97YaZ3rs4...

1 comments

> The problem is that equality is still strict binary equality for text, for obscure technical reasons

AKA performance.