X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C337ED1C9F7 for ; Mon, 22 Sep 2003 17:05:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 65439-04 for ; Mon, 22 Sep 2003 14:05:02 -0300 (ADT) Received: from mail.nucleus.com (mail1.nucleus.com [207.34.101.2]) by svr1.postgresql.org (Postfix) with ESMTP id 910C0D1CA05 for ; Mon, 22 Sep 2003 14:04:51 -0300 (ADT) Received: from dsl-mtryl-209-5-169-111-cgy.nucleus.com (unverified [209.5.169.111]) by mail.nucleus.com (Vircom SMTPRS 2.1.258) with ESMTP id ; Mon, 22 Sep 2003 11:04:42 -0600 From: "Andrew J. Kopciuch" Reply-To: akopciuch@olympusproject.org Organization: Olympus Open Source Project To: Wei Weng , Richard Huxton Subject: Re: GiST and full text search Date: Mon, 22 Sep 2003 11:03:19 -0600 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <200309221624.01700.dev@archonet.com> In-Reply-To: X-MailKey: Flyers winning makes BDDF happy MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200309221103.19681.akopciuch@olympusproject.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/260 X-Sequence-Number: 15238 On Monday 22 September 2003 09:41, Wei Weng wrote: > The production server uses PostgreSQL 7.3.1 right now, so I am only > looking at contrib/tsearch. > tsearch2 is compatible, and available for any version of PosgreSQL 7.3. It is not included in the contrib directory. It is available in CVS head and will be in 7.4 contrib AFAIK. You can download the stable version here: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz There are full installation instructions in the introdution. See below. > I read through the README file. It only seems to offer a way to FTS > through one 'text' column in the table. How do I create a 'txtidx' column > that combines two or even more 'text' columns in the table? > Read the introduction documentation. It explains this in detail, plus many other things you might want to know: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html Andy