Re: Text search with multiple tables

Поиск

Список

Период

Сортировка

От	Mont Rothstein
Тема	Re: Text search with multiple tables
Дата	1 мая 2008 г. 13:51:20
Msg-id	467a83630805010951i6807af9alc09dddbf38868287@mail.gmail.com обсуждение
Ответ на	Text search with multiple tables ("Mont Rothstein" <mont.rothstein@gmail.com>)
Список	pgsql-general

Дерево обсуждения

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 <mont.rothstein@gmail.com> 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

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: Text search with multiple tables