tsearch2 question...
От | Net Virtual Mailing Lists |
---|---|
Тема | tsearch2 question... |
Дата | |
Msg-id | 20031019142322.13592@mail.net-virtual.com обсуждение исходный текст |
Ответы |
Re: tsearch2 question...
|
Список | pgsql-general |
Hello, I have a quick question regarding tsearch2, hopefully this is an okay place to ask because I couldn't find a tsearch2-specific mailing list.. Anyways, when the field which is indexed using tsearch2 is displayed in it's entirety I want the searched keywords to be highlighted, just as in a headline except that the entire document gets displayed instead of just a summary of it.. In order for this to work well, it would seem that I need the same code path as that used to generate the headline to begin with, otherwise differences in stemming/etc could cause mis-matches... My thought was to do: SELECT bodytext_id,headline(bodytext, to_tsquery('default','SEARCH_KEYS'),' MaxWords=999999999,MinWords=999999999,ShortWord=0') FROM some_table WHERE bodytext_id=SOME_ID Does this seem like a 'reasonable' way to do this?... In not is there a better way that you can think of?... Thanks! - GReg
В списке pgsql-general по дате отправления: