Search Postgresql Archives

Re: change the stop words file for tsearch2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ottavio,

On Mon, 7 May 2007, Ottavio Campana wrote:

How can I change the name of the file with the stop words used by tsearch2?

I tried searching in the pg_ts_* tables, but I didn't find anything.

Moreover, suppose you have a table with (text,ts_vector,boolean)
columns. Do you think it might be possible to use two different files of
stop words, in case the boolean field is true or false?

only dictionaries use stop-words, so check dict_initoption in pg_ts_dict table:

w=# select dict_name,dict_initoption from pg_ts_dict;
     dict_name      |      dict_initoption
--------------------+---------------------------
 simple             |
 en_stem            | contrib/english.stop
 ru_stem_koi8       | contrib/russian.stop
 ru_stem_utf8       | contrib/russian.stop.utf8
 ispell_template    |
 synonym            |
 thesaurus_template |

btw, did you read tsearch2 documentation ?

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux