Julius Tuskenis wrote:
> I've made a function that converts lithuanian letters to latin and
> use it like fnk_latin(username) ILIKE fnk_latin('kestas').
> Now the problem is performance.
> Maybe some special index would help?
create index tblname_username_latin on tblname
((fnk_latin(username)));
You might want to have that function force all letters to lowercase.
It might also help to specify varchar_pattern_ops.
-Kevin