Re: [GENERAL] tsvector Column Indexing Across Two Tables

2009-09-07 Thread Oleg Bartunov
On Sun, 6 Sep 2009, APseudoUtopia wrote: Sorry to post again. I was reading over the documentation and I discovered that it is possible to concatenate two tsvector's together. So I can concat the subject tsvector index from the forums_topics table with the post body in forums_posts. If you

[GENERAL] tsvector Column Indexing Across Two Tables

2009-09-06 Thread APseudoUtopia
Hey list, I have a forum. I'm in the process of adding a full-text search. The forum is split into a couple tables, including forums_posts and forums_topics. The latter contains only the title of the topic and some other information, like an ID number. The forums_posts table contains the body of

Re: [GENERAL] tsvector Column Indexing Across Two Tables

2009-09-06 Thread APseudoUtopia
On Sun, Sep 6, 2009 at 9:57 PM, APseudoUtopiaapseudouto...@gmail.com wrote: Hey list, I have a forum. I'm in the process of adding a full-text search. The forum is split into a couple tables, including forums_posts and forums_topics. The latter contains only the title of the topic and some