tsearch2 questions - Mailing list pgsql-general

From Joshua N Pritikin
Subject tsearch2 questions
Date
Msg-id 20070704061734.GI25916@always.joy.eth.net
Whole thread Raw
Responses Re: tsearch2 questions
List 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 by date:

Previous
From: Chris
Date:
Subject: Re: How do I aggregate data from multiple rows into a delimited list?
Next
From: "D. Dante Lorenso"
Date:
Subject: Re: How do I aggregate data from multiple rows into a delimited list?