Today's your lucky day (I think), because I was looking for (and used) the
aggregate function mentioned below just before reading your question.
At 11:03 AM 1/7/06, Tomas Vondra wrote:
1) How to create a "table" in the form
documtent_id | word_1 | word_2 | ... | word_n
-
Hello,
in several apps running over postgres 8.0/8.1 I've used following
"full-text" search engine - imagine there are two tables:
1) Documents - with "docId", "title", "abstract" and "body" columns
2) Index - with "docId", "word" and "score"
It's very easy to build the Index from the Documents
