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 по дате отправления: