Re: how to speed ilike

Julius Tuskenis <julius@nsoft.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