Postgres Pro
Downloads
Home   >   mailing lists

Search fields in multiple tables - Mailing list pgsql-sql

From Raj Mathur
Subject Search fields in multiple tables
Date
Msg-id 200810160931.12282.raju@linux-delhi.org
Whole thread Raw
List pgsql-sql
Tree view 
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 by date:

Previous
From: Frank Bax
Date:
Subject: Re: Most efficient way to achieve this ts_query
Next
From: "Jamie Tufnell"
Date:
Subject: Re: Most efficient way to achieve this ts_query