Re: LIKE and REGEX optimization

Chris Browne wrote:
> The only idea that comes to mind to follow that is to look into
> tsearch.  On PostgreSQL 8.3, it's built in; on 8.2 and earlier, it's a
> "contrib" module.  It allows indexing on words inside columns, which
> would seem to fit your requirement.

You might want to google for "postgresql trigram" too. Some notes at the
location below.
http://www.sai.msu.su/~megera/oddmuse/index.cgi/ReadmeTrgm

It's more of a substring search than tsearch2 is, so might meet your
needs better. It's in the "contrib" package / source directory.

--
   Richard Huxton
   Archonet Ltd