Thread: tsearch2 and parsing host strings
A question related to tsearch2 functionality in postgres:
When I run the following query:
select to_tsvector('default', 'website.com')
I get "' website.com':1".
What I need to get back is 'website':1 instead. I can see that the parser correctly determines term website.com as a host token, which then are routed (on my, and I believe default, configuration) to 'default' dictionary (en_stem for me). Has anyone written a special dictionary for cases just like the above, so that I could change the pg_ts_cfgmap to map it to that special dictionary?
Is there any way I can accomplish this with tsearch2?
Thanks,
Laimis
When I run the following query:
select to_tsvector('default', 'website.com')
I get "' website.com':1".
What I need to get back is 'website':1 instead. I can see that the parser correctly determines term website.com as a host token, which then are routed (on my, and I believe default, configuration) to 'default' dictionary (en_stem for me). Has anyone written a special dictionary for cases just like the above, so that I could change the pg_ts_cfgmap to map it to that special dictionary?
Is there any way I can accomplish this with tsearch2?
Thanks,
Laimis
On Tue, 11 Sep 2007, Laimonas Simutis wrote: > A question related to tsearch2 functionality in postgres: > > When I run the following query: > > select to_tsvector('default', 'website.com') > > I get "'website.com':1". > > What I need to get back is 'website':1 instead. I can see that the parser > correctly determines term website.com as a host token, which then are routed > (on my, and I believe default, configuration) to 'default' dictionary > (en_stem for me). Has anyone written a special dictionary for cases just > like the above, so that I could change the pg_ts_cfgmap to map it to that > special dictionary? > > Is there any way I can accomplish this with tsearch2? Check my reply about pg_regex dictionary. Simple regex will save you. > > > Thanks, > > Laimis > 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