Re: GiST and full text search

From: "Andrew J(dot) Kopciuch" <akopciuch(at)olympusproject(dot)org>
To: Wei Weng <wweng(at)kencast(dot)com>, Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: GiST and full text search
Date: 2003-09-22 17:03:19
Message-ID: 200309221103.19681.akopciuch@olympusproject.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2003-09-22 22:34:00 Re: Backup of multiple tables
Previous Message Richard Huxton 2003-09-22 16:55:09 Re: GiST and full text search