Julius Tuskenis <julius(at)nsoft(dot)lt> writes:
> Tried that too, but seem to me that ILIKE doesn't use the index. I'm using
> username ilike '%blablabla%' , so maybe theres no way for ilike to benefit
> from an index.
See pg_trgm and Full Text Search.
http://www.postgresql.org/docs/8.4/interactive/pgtrgm.html
http://www.postgresql.org/docs/8.4/interactive/textsearch.html
Regards,
--
dim