Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AE56B9FB312 for ; Fri, 23 Feb 2007 14:35:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 60826-04 for ; Fri, 23 Feb 2007 14:34:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from zenon.apartia.fr (zenon.apartia.fr [82.66.93.83]) by postgresql.org (Postfix) with ESMTP id B000E9FA410 for ; Fri, 23 Feb 2007 14:35:00 -0400 (AST) Received: from trajan.apartia.fr (trajan.apartia.fr [10.0.3.121]) by zenon.apartia.fr (Postfix) with ESMTP id A3DF4F0ABE708 for ; Fri, 23 Feb 2007 19:34:56 +0100 (CET) Received: by trajan.apartia.fr (Postfix, from userid 1000) id 5F7EB2534C2A; Fri, 23 Feb 2007 19:34:52 +0100 (CET) Date: Fri, 23 Feb 2007 19:34:52 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: simple web search Message-ID: <20070223183452.GA23406@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <20070223162731.GA25577@apartia.fr> <1172255474.736.1.camel@pampa> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1172255474.736.1.camel@pampa> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.414 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/235 X-Sequence-Number: 27569 On Fri, Feb 23, 2007 at 01:31:14PM -0500, Joe wrote: > 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. Thanks Joe, I initially wanted to avoid dipping my toe into tsearch2 but it might be what I need after all :)