I found a way to do this but I don't know if there is a better way. What I did was to create a separate index on each table and construct a query like:
SELECT * FROM a WHERE (to_tsvector(...) @@ to_tsquery(...)) OR primaryKey IN (SELECT distinct(foreign_key) FROM b WHERE to_tsvector(...) @@ to_tsquery(...)) Is there a better way to do this? Thanks, -Mont On Thu, May 1, 2008 at 8:48 AM, Mont Rothstein <[EMAIL PROTECTED]> wrote: > Is it possible to perform a text search with tables A-->>B returning A for > matches in B? > What I want to do is to be able take columns from both A and B and perform > a search based on the keywords entered by the user that matches A, B, or > both but always returns A. > > Can this be done? > > Thanks, > -Mont > >
