Text search with multiple tables

From: "Mont Rothstein" <mont(dot)rothstein(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Text search with multiple tables
Date: 2008-05-01 15:48:36
Message-ID: 467a83630805010848g6a7a9171mc59a6c07b85b58de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-05-01 16:44:02 Re: Deadlock situation?
Previous Message Dan Armbrust 2008-05-01 15:38:46 Re: Deadlock situation?