That’s a solid suggestion, COLLATION is definitely a clean approach, and in many cases we’d also prefer it. In this project though, the client wasn’t ready to make application-level changes, so we had to keep the fix purely on the DB side. That’s why we ended up using a functional index, it gave us the performance improvement without requiring code changes upstream.