Thread: change the stop words file for tsearch2

change the stop words file for tsearch2

From
Ottavio Campana
Date:
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?

Ciao

--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.


Attachment

Re: change the stop words file for tsearch2

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