stem & tsearch2, want different stemmed words
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
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
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