| 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: | Whole Thread | Raw Message | 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" |