2 ms·
Maybe this helps: https://stackoverflow.com/posts/11007216/revisions https://stackoverflow.com/posts/11007216/revisions ? My gut tells me that I would do it in
by dijit 4y ago
Maybe this helps: https://stackoverflow.com/posts/11007216/revisions https://stackoverflow.com/posts/11007216/revisions ?
My gut tells me that I would do it in the query itself though, and not rely on the collation. Maybe I am misunderstanding.
- sjamaan 4y agoLook under "Update for Postgres 12 or later", there they create a collation, an index to make use of it and then a query to make use of it: SELECT \* FROM users WHERE name = 'João' COLLATE ignore_accent;