Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 492C59FB8BB for ; Mon, 26 Feb 2007 15:47:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 19892-05 for ; Mon, 26 Feb 2007 15:46:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from tanagra.summersault.com (tanagra.summersault.com [12.161.105.149]) by postgresql.org (Postfix) with ESMTP id 6F7439FB977 for ; Mon, 26 Feb 2007 15:46:55 -0400 (AST) Received: (qmail 29382 invoked from network); 26 Feb 2007 19:46:54 -0000 Received: from simba.summersault.com (HELO ?192.168.97.182?) (mark@192.168.97.182) by tanagra.summersault.com with ESMTPA; 26 Feb 2007 19:46:54 -0000 Message-ID: <45E3390A.9000908@summersault.com> Date: Mon, 26 Feb 2007 14:46:18 -0500 From: Mark Stosberg User-Agent: Thunderbird 1.5.0.8 (X11/20061109) MIME-Version: 1.0 To: Madison Kelly CC: pgsql-performance@postgresql.org Subject: Re: Writting a "search engine" for a pgsql DB References: <45E30ADA.2050700@alteeve.com> <45E31300.4070701@commandprompt.com> <45E31D28.2020402@alteeve.com> <45E323AB.1040009@summersault.com> <45E32E21.9090901@alteeve.com> In-Reply-To: <45E32E21.9090901@alteeve.com> X-Enigmail-Version: 0.94.1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/309 X-Sequence-Number: 23363 > > Now see, this is exactly the kind of sagely advice I was hoping for! :) > > I'll look into tsearch2, and failing that for some reason, I love the > keyword table idea. For example keyword search code, you can try this package: http://downloads.sourceforge.net/cascade/cascade-devel-pieces-1.1.tgz?modtime=999556617&big_mirror=0 There is a "keywords" subdirectory with the Perl and SQL. I'm sure this code is not ideal in a number of ways: 1. It's from 2001. 2. It doesn't actually function on it's own anymore. However, you can read the code and get ideas. 3. I'm sure someone has a better looking/functioning example! Anyway, it's there if you want to take a look. Mark