Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B59EE9FC28C for ; Fri, 23 Feb 2007 14:30:56 -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 60085-02 for ; Fri, 23 Feb 2007 14:30:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id F0A5B9FC230 for ; Fri, 23 Feb 2007 14:30:52 -0400 (AST) Received: from [192.168.7.5] ([71.101.14.120]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JDX00J1DI2ZL648@vms048.mailsrvcs.net> for pgsql-sql@postgresql.org; Fri, 23 Feb 2007 12:30:35 -0600 (CST) Date: Fri, 23 Feb 2007 13:31:14 -0500 From: Joe Subject: Re: simple web search In-reply-to: <20070223162731.GA25577@apartia.fr> To: Louis-David Mitterrand Cc: pgsql-sql@postgresql.org Message-id: <1172255474.736.1.camel@pampa> Organization: Freedom Circle, LLC MIME-version: 1.0 X-Mailer: Evolution 2.8.3 FreeBSD GNOME Team Port Content-type: text/plain Content-transfer-encoding: 7bit References: <20070223162731.GA25577@apartia.fr> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/233 X-Sequence-Number: 27567 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