Search fields in multiple tables

Поиск
Список
Период
Сортировка
От Raj Mathur
Тема Search fields in multiple tables
Дата
Msg-id 200810160931.12282.raju@linux-delhi.org
обсуждение исходный текст
Список pgsql-sql
Hi,

I have some information about books spread over multiple tables (title, 
authors, ISBN, blurb, publisher, etc.)  Is there any convenient way in 
PostgreSQL to allow a user to search these in a single operation?

If there is, would there be some way to assign weights to the fields?  
E.g. a match on title would rate higher than a match on publisher or on 
blurb.

Regards,

-- Raju
-- 
Raj Mathur                raju@kandalaya.org      http://kandalaya.org/      GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968
D0EFCC68 D17F
 
PsyTrance & Chill: http://schizoid.in/   ||   It is the mind that moves


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

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: Most efficient way to achieve this ts_query
Следующее
От: "Jamie Tufnell"
Дата:
Сообщение: Re: Most efficient way to achieve this ts_query