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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
