Re: FTI Queries and Explain (long)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gordan Bobic <gordan(at)bobich(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FTI Queries and Explain (long)
Date: 2001-10-18 18:59:09
Message-ID: 25141.1003431549@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gordan Bobic <gordan(at)bobich(dot)net> writes:
> 1) Modify the FTI function to split the text field only at non-alphanumeric
> characters, and only return whole words, rather than substrings of words.

Sure, if that works better for you. The reason FTI is in contrib is
that it's not really ready for prime time (if it were, it'd be in the
mainline code). Feel free to hack it to make it match your application
better.

> Is there anything in the pipeline for addressing FTI in the next
> version of PostgreSQL?

There is a completely new contrib module 'tsearch' that will probably
supersede FTI over time. I haven't looked at it closely myself, though.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holt, Jack C. 2001-10-18 19:06:00 Re: Accessing PostgreSQL through Apache and PHP4 on Linux
Previous Message wsheldah 2001-10-18 18:58:39 Re: [OT] Accessing PostgreSQL through Apache and PHP4