Re: [GENERAL] "simple" dict with stop words in tsearch2

2007-01-29 Thread Pierre Thibaudeau

Brilliant!  Thank you!


> In tsearch2, I would like to use the "simple" dictionary along with my
> own list of stopwords.
> [...]

sure, just specify dict_initoption. For example,
test=# update pg_ts_dict set  dict_initoption='contrib/english.stop' where 
dict_name='simple';
UPDATE 1
test=# select lexize('simple', 'the');
  lexize

  {}
(1 row)


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [GENERAL] "simple" dict with stop words in tsearch2

2007-01-29 Thread Oleg Bartunov

On Mon, 29 Jan 2007, Pierre Thibaudeau wrote:


In tsearch2, I would like to use the "simple" dictionary along with my
own list of stopwords.

In other words, once the text is parsed into tokens, no stemming
whatsoever, but stopwords are removed.

Is there an easy way to produce that result, using the standard
"simple" dictionary?


sure, just specify dict_initoption. For example, 
test=# update pg_ts_dict set  dict_initoption='contrib/english.stop' where dict_name='simple';

UPDATE 1
test=# select lexize('simple', 'the');
 lexize

 {}
(1 row)




---(end of broadcast)---
TIP 4: Have you searched our list archives?

 http://archives.postgresql.org/



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

---(end of broadcast)---
TIP 6: explain analyze is your friend


[GENERAL] "simple" dict with stop words in tsearch2

2007-01-29 Thread Pierre Thibaudeau

In tsearch2, I would like to use the "simple" dictionary along with my
own list of stopwords.

In other words, once the text is parsed into tokens, no stemming
whatsoever, but stopwords are removed.

Is there an easy way to produce that result, using the standard
"simple" dictionary?

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/