simple web search - Mailing list pgsql-sql

From Louis-David Mitterrand
Subject simple web search
Date
Msg-id 20070223162731.GA25577@apartia.fr
Whole thread Raw
Responses Re: simple web search  (chester c young <chestercyoung@yahoo.com>)
Re: simple web search  (Joe <dev@freedomcircle.net>)
List pgsql-sql
Hello,

I'm considering implementing a search box on my review web site 
http://lesculturelles.net and am looking for a simple way to match 
entered words against several columns on related tables: show.show_name, 
story.title, person.firtname, person.lastname, etc.

What is the most elegant way to build a single query to match search 
words with multiple columns?

Thanks,


pgsql-sql by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)
Next
From: chester c young
Date:
Subject: Re: simple web search