From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | Mage <mage(at)mage(dot)hu> |
Subject: | Re: partial word matching |
Date: | 2007-05-23 08:13:08 |
Message-ID: | 4653F794.6060906@theendofthetunnel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 22.05.2007 22:49, Mage wrote:
> as far as I know treach2 doesn't support partial word matching. Last
> time I checked it didn't. (I also googled before I asking this).
>
> Am I wrong? If not, we would implement some FTI, something like the old
> and decrepated FTI-crontib. Where should we start reading tutorials? I
> googled for this question too, however most results were about tsearch2
> or old FTI contrib. I would read something advanced about this topic.
> Something that must be read.
Partial word matching with TSearch can be done, just maintain all lexems
in a separate table, scan that with LIKE '%foo%' in a sub query that
generates the actual TSearch query. Additionally you might combine that
with pg_trgm. Another way is to use the lexems table for fancy auto
completion in AJAX web forms.
--
Regards,
Hannes Dorbath
From | Date | Subject | |
---|---|---|---|
Next Message | Purusothaman A | 2007-05-23 08:34:09 | Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. |
Previous Message | Albe Laurenz | 2007-05-23 07:12:47 | Re: Lock table, Select for update and Serialization error |