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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
