Recently you answered my question on how to make a field case insensitive. You showed me how to do it with the extension and data type citext.
How do I make the same field accent insensitive as well? I managed to install the extension "unaccent" in Postgres 9.1.2 using create extension. Unfortunately I could only use it in the where clauses of sql statements. I want to make a field behave accent insensitive during comparisons just like citext does for case insensitive.
The reason I want to do this is because it's one of the options I am used to in Microsoft SQL Server. I can do something like this:
select * from table1 where unaccent(field1)='John';
I can also do this:
select * from table1 where unaccent(field1)::citext='JohN';
But I want field1 to have this a default behaviour?