stem & tsearch2, want different stemmed words

Started by Marcus Engenealmost 19 years ago3 messagesgeneral
Jump to latest
#1Marcus Engene
mengpg2@engene.se

Hi!

bond=> SELECT to_tsvector('default','animation animal');
to_tsvector
-------------
'anim':1,2
(1 row)

bond=>

Sorry for a silly question, I wonder, how do I override this? I would
want different stemmed words for these.

Best regards,
Marcus

#2Oleg Bartunov
oleg@sai.msu.su
In reply to: Marcus Engene (#1)
Re: stem & tsearch2, want different stemmed words

On Sat, 30 Jun 2007, Marcus Engene wrote:

Hi!

bond=> SELECT to_tsvector('default','animation animal');
to_tsvector
-------------
'anim':1,2
(1 row)

bond=>

Sorry for a silly question, I wonder, how do I override this? I would want
different stemmed words for these.

create synonym dictionary. Read about this
http://www.sai.msu.su/~megera/wiki/Tsearch_V2_Notes

Best regards,
Marcus

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

#3Marcus Engene
mengpg2@engene.se
In reply to: Oleg Bartunov (#2)
Re: stem & tsearch2, want different stemmed words

Oleg Bartunov wrote:

On Sat, 30 Jun 2007, Marcus Engene wrote:

Hi!

bond=> SELECT to_tsvector('default','animation animal');
to_tsvector
-------------
'anim':1,2
(1 row)

bond=>

Sorry for a silly question, I wonder, how do I override this? I would
want different stemmed words for these.

create synonym dictionary. Read about this
http://www.sai.msu.su/~megera/wiki/Tsearch_V2_Notes

Many thanks!

For future googlers: do check what was in your pg_ts_cfgmap before updating;

update pg_ts_cfgmap set dict_name='{ts_p5_syn,en_stem}' where
ts_name='default' and tok_alias in
('lword', 'lpart_hword','lhword' );

;-P

Best regards,
Marcus