Index: contrib/pg_trgm/README.pg_trgm =================================================================== RCS file: /projects/cvsroot/pgsql/contrib/pg_trgm/README.pg_trgm,v retrieving revision 1.1 diff -c -r1.1 README.pg_trgm *** contrib/pg_trgm/README.pg_trgm 31 May 2004 17:18:11 -0000 1.1 --- contrib/pg_trgm/README.pg_trgm 26 Nov 2004 01:31:39 -0000 *************** *** 100,110 **** The first step is to generate an auxiliary table containing all the unique words in the Tsearch2 index: ! CREATE TABLE words AS ! SELECT word FROM stat('SELECT vector FROM documents'); ! Where 'documents' is the table that contains the Tsearch2 index ! column 'vector', of type 'tsvector'. Next, create a trigram index on the word column: --- 100,114 ---- The first step is to generate an auxiliary table containing all the unique words in the Tsearch2 index: ! CREATE TABLE words AS SELECT word FROM ! stat('SELECT to_tsvector(''simple'', bodytext) FROM documents'); ! Where 'documents' is a table that has a text field 'bodytext' ! that TSearch2 is used to search. The use of the 'simple' dictionary ! with the to_tsvector function, instead of just using the already ! existing vector is to avoid creating a list of already stemmed ! words. This way, only the original, unstemmed words are added ! to the word list. Next, create a trigram index on the word column: