tsearch2 questions

Поиск
Список
Период
Сортировка
От Joshua N Pritikin
Тема tsearch2 questions
Дата
Msg-id 20070704061734.GI25916@always.joy.eth.net
обсуждение исходный текст
Ответы Re: tsearch2 questions  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-general
1. What is the advantage of the tsearch2() trigger? Why can't I write my
own trigger which does approximately:

  UPDATE manuscript set manuscript_vector =
    setweight(to_tsvector(manuscript_genre), 'A') ||
    setweight(to_tsvector(manuscript_title), 'B') ||
    to_tsvector(manuscript_abstract);

2. Is there a way to know in advance the maximum return value of the
rank function? I have lots of other information to include in the
goodness-of-match score besides the fulltext match rank so I would
prefer a tsearch2 rank score between 0 and 1. Do I need to write my own
rank function?

--
Make April 15 just another day, visit http://fairtax.org

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: How do I aggregate data from multiple rows into a delimited list?
Следующее
От: "D. Dante Lorenso"
Дата:
Сообщение: Re: How do I aggregate data from multiple rows into a delimited list?