Re: Fulltext Index and Search

On Tue, 26 Feb 2002, Samuel J. Sutjiono wrote:

> Can you share any example showing how it's done ?

http://openftx.sourceforge.net/

for myself, i just read the README and it showed how to ALTER TABLE your
existing table to add another column with txtidx type. then you can do an
UPDATE table SET newcolidx=txt2txtidx(oldtxtcol);

and use triggers etc for future updates or inserts.

i'm amazed how fast it is. there is no phrase or such though. but it works
very well as is. i think openftx also does something with relevancy
ranking etc.

>
> Thanks
> ----- Original Message -----
> From: "Thomas T. Thai" <tom(at)minnesota(dot)com>
> To: "Stefan Weiss" <sw(at)typ1(dot)de>
> Cc: <pgsql-general(at)postgresql(dot)org>
> Sent: Tuesday, February 26, 2002 2:22 PM
> Subject: Re: [GENERAL] Fulltext Index and Search
>
>
> > On Mon, 25 Feb 2002, Stefan Weiss wrote:
> >
> > > Hi,
> > >
> > > ist it possible to make a fulltextsearch about more than one column?
> >
> > contrib/tsearch could do that for you. and it's very fast!
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
>
>

---
Thomas T. Thai | Minnesota.com | tom(at)minnesota(dot)com | 612.220.6220
Visit http://www.minnesota.com/