From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Patches" <pgsql-patches(at)postgresql(dot)org> |
Subject: | Patch to contrib/fulltextindex/fti.sql |
Date: | 2001-07-30 06:24:09 |
Message-ID: | ECEHIKNFIMMECLEBJFIGEEGJCBAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 | Content-Type | Size |
---|---|---|
fti.diff | application/octet-stream | 2.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Kenji Sugita | 2001-07-30 08:05:00 | Patch to enable window size detection code of psql for Solaris platform |
Previous Message | Tom Lane | 2001-07-30 04:24:14 | Re: Revised Patch to allow multiple table locks in "Unison" |