Skip site navigation (1) Skip section navigation (2)

Patch to contrib/fulltextindex/fti.sql

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 (view raw or flat)
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: fti.diff
Description: application/octet-stream (2.1 KB)

Responses

pgsql-patches by date

Next:From: Kenji SugitaDate: 2001-07-30 08:05:00
Subject: Patch to enable window size detection code of psql for Solaris platform
Previous:From: Tom LaneDate: 2001-07-30 04:24:14
Subject: Re: Revised Patch to allow multiple table locks in "Unison"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group