Re: simple web search - Mailing list pgsql-sql

From Joe
Subject Re: simple web search
Date
Msg-id 1172255474.736.1.camel@pampa
Whole thread Raw
In response to simple web search  (Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>)
Responses Re: simple web search  (Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>)
List pgsql-sql
Hello Louis-David,

On Fri, 2007-02-23 at 17:27 +0100, Louis-David Mitterrand wrote:
> 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?

You may want to take a look at contrib/tsearch2.

Joe



pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: Re: simple web search
Next
From: Oleg Bartunov
Date:
Subject: Re: simple web search