Hi 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? Thanks H.F.
