Search fields in multiple tables

From: Raj Mathur <raju(at)linux-delhi(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Search fields in multiple tables
Date: 2008-10-16 04:01:12
Message-ID: 200810160931.12282.raju@linux-delhi.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)kandalaya(dot)org http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
PsyTrance & Chill: http://schizoid.in/ || It is the mind that moves

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jamie Tufnell 2008-10-16 04:41:22 Re: Most efficient way to achieve this ts_query
Previous Message Frank Bax 2008-10-16 03:49:29 Re: Most efficient way to achieve this ts_query