Re: stem & tsearch2, want different stemmed words - Mailing list pgsql-general

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