Re: change the stop words file for tsearch2

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83