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