SEO

#1 (**permalink**) 04-09-2008, 05:23 PM

Hello,

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.

Thank you.

(Before asking I was searching in my last 30k e-mails from this mailing
list. Sadly they were not full-text indexed.)

Mage

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-09-2008, 05:23 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode