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