Re: change the stop words file for tsearch2 - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: change the stop words file for tsearch2
Date
Msg-id Pine.LNX.4.64.0705080840550.12152@sn.sai.msu.ru
Whole thread Raw
In response to change the stop words file for tsearch2  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tokenize string for tsearch?
Next
From: "A. Kretschmer"
Date:
Subject: Re: Postgre Sql 7.3 connection problem