Hi,
Would it be possible to mark functions in contrib/unnaccent [1] as IMMUTABLE?
We would gain the possibility to use it to enforce uniqueness.
I understand that the main drawback is that unicode rules are
periodically updated. So it would be needed to reindex indices on
unaccent() after upgrade.
Thank you,
petru ghita
[1] https://github.com/postgres/postgres/tree/master/contrib/unaccent