Re: Search fields in multiple tables

Howdy, Raju.

Could you please provide a more concrete example of what you need?

What information would you like your query to return exactly?
An ordered set of records? Ordered by rank...? Please 
give an example of a search operation and intended result

Best,
Oliveiros

----- Original Message ----- 
From: "Raj Mathur" <raju@linux-delhi.org>
To: <pgsql-sql@postgresql.org>
Sent: Thursday, October 16, 2008 5:01 AM
Subject: [SQL] Search fields in multiple tables


> 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 D0EF CC68 D17F
> PsyTrance & Chill: http://schizoid.in/   ||   It is the mind that moves
> 
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>