Patch to contrib/fulltextindex/fti.sql - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Patch to contrib/fulltextindex/fti.sql
Date
Msg-id ECEHIKNFIMMECLEBJFIGEEGJCBAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: Patch to contrib/fulltextindex/fti.sql
Re: Patch to contrib/fulltextindex/fti.sql
Re: Patch to contrib/fulltextindex/fti.sql
List pgsql-patches
The fti.pl supplied with the fulltextindex module generate ALL possible
substrings of two characters or greater, and is case-sensitive.

This patch makes it work correctly.  It generates only the suffixes of each
word, plus lowercases them - as specified by the README file.

This brings it into line with the fti.c function, makes it case-insensitive
properly, removes the problem with duplicate rows being returned from an fti
search and greatly reduces the size of the generated index table.

It was written by my co-worker, Brett Toolin.

Chris

Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [INTERFACES] WIN32 MULTIBYTE
Next
From: Kenji Sugita
Date:
Subject: Patch to enable window size detection code of psql for Solaris platform