On Wed, 2007-05-23 at 19:48 -0400, Robert Fitzpatrick wrote: > On Wed, 2007-05-23 at 18:53 -0400, Ericson Smith wrote: > > Yeah, we've used Tsearch with joins and searches on other fields on > > the tsearch table no problem. Tsearches are just another part of a > > WHERE clause. > > > > And can there be Tsearch fields built based on fields in different > tables? Where can I find the best docs for TSearch2? I'm looking for > information pertaining to how TSearch can help in my situation, instead > of building a view with a lot of joins causing absurd amount of rows > returned.
Of course, what was I thinking! After reading through the TSearch stuff I see the objective is to index multiple columns. There would be no way to reference a unique record from an index of columns over multiple tables. So, it is looking like a build of the query string is going to have to take place on whichever tables the fields are in while limiting what fields the user can search (depending whether fields are in different tables), that versus a view with everything is what I should be doing? -- Robert ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster