Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 011E09FC2BB for ; Fri, 23 Feb 2007 12:27:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 41830-02-5 for ; Fri, 23 Feb 2007 12:27:32 -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 16C7F9FC2BD for ; Fri, 23 Feb 2007 12:27:32 -0400 (AST) Received: from styx.apartia.fr (styx.apartia.fr [10.0.3.109]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "styx.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by zenon.apartia.fr (Postfix) with ESMTP id 1B81BF087ED3A for ; Fri, 23 Feb 2007 17:27:31 +0100 (CET) Received: by styx.apartia.fr (Postfix, from userid 1000) id 386FCB2AD42D; Fri, 23 Feb 2007 17:27:31 +0100 (CET) Date: Fri, 23 Feb 2007 17:27:31 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: simple web search Message-ID: <20070223162731.GA25577@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.536 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/229 X-Sequence-Number: 27563 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,