simple web search

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: simple web search
Date: 2007-02-23 16:27:31
Message-ID: 20070223162731.GA25577@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2007-02-23 18:01:22 Re: simple web search
Previous Message Jim C. Nasby 2007-02-23 16:24:27 Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)