From: | "Oliveiros Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt> |
---|---|
To: | <raju(at)linux-delhi(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Search fields in multiple tables |
Date: | 2008-10-16 14:02:59 |
Message-ID: | 018b01c92f97$e5c83440$ec5a3d0a@marktestcr.marktest.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)linux-delhi(dot)org>
To: <pgsql-sql(at)postgresql(dot)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(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
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gerardo Herzig | 2008-10-17 11:45:23 | returning count(*) when it is > 1, else -1 |
Previous Message | Jamie Tufnell | 2008-10-16 04:41:22 | Re: Most efficient way to achieve this ts_query |