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" <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED] 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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
