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
You might want to have that function force all letters to lowercase.
It might also help to specify varchar_pattern_ops.
pgsql-admin by date
|Next:||From: Kevin Grittner||Date: 2010-01-25 13:24:54|
|Subject: Re: max_fsm_pages question|
|Previous:||From: Julius Tuskenis||Date: 2010-01-25 12:23:09|
|Subject: how to speed ilike|