Re: [SQL] Search fields in multiple tables

2008-10-16 Thread Oliveiros Cristina
Message - From: "Raj Mathur" <[EMAIL PROTECTED]> To: 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 c

[SQL] Search fields in multiple tables

2008-10-15 Thread Raj Mathur
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 mat