Re: stem & tsearch2, want different stemmed words

From: Marcus Engene <mengpg2(at)engene(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: stem & tsearch2, want different stemmed words
Date: 2007-07-01 13:21:31
Message-ID: 4687AA5B.2060601@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2007-07-01 15:27:01 Re: [ASK] create data ware house in postgre
Previous Message Magnus Hagander 2007-07-01 12:00:30 Re: postgressqlnot support inwindows 2000