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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
