Improvement to pg_trgm readme

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Improvement to pg_trgm readme
Дата
Msg-id
41A68829.2050106@familyhealth.com.au
Список
Дерево обсуждения
Improvement to pg_trgm readme Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Improvement to pg_trgm readme Tom Lane <tgl@sss.pgh.pa.us>
This adds mention of my latest tweak to the tsearch2/pg_trgm 
integration.  It is much better to create a word list of unstemmed words 
than stemmed ones.

Chris
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:
  
В списке pgsql-patches по дате отправления
От: Troels Arvin
Дата:
От: Flynn
Дата:
FAQ