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