Re: How to use the full text index feature on PostgreSQL - Mailing list pgsql-general

Matthew T. O'Connor wrote:
> Chris wrote:
>> aBBISh wrote:
>> You need to install & setup tsearch2.
>>
>> I have a small article about how to do that here:
>>
>> http://www.designmagick.com/article/27/
>
> Also on page 3 you say, "(normal indexes will only index the first 255
> characters of a 'text' field)."
>
> Is that true?

I thought it was the first 8k? There is also an article here:

http://www.devx.com/opensource/Article/21674/1954?pf=true

Joshua D. Drake


>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/