| From: | Tilmann Singer <tils-pgsql(at)tils(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | tsearch2 dictionary that indexes substrings? |
| Date: | 2007-04-19 17:17:04 |
| Message-ID: | 20070419171704.GE21437@tils.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
In this http://archive.netbsd.se/?ml=pgsql-hackers&a=2006-10&t=2475028
thread Teodor Sigaev describes a way to make tsearch2 index substrings
of words:
> Brain storm method:
>
> Develop a dictionary which returns all substring for lexeme, for
> example for word foobar it will be 'foobar fooba foob foo fo oobar
> ooba oob oo obar oba ob bar ba ar'
Did anyone do that already?
If I understand it correctly such a dictionary would require to write
a custom C component - is that correct? Or could I get away with
writing a plpgsql function that does the above and hooking that
somehow into the tsearch2 config?
thanks, Til
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Listmail | 2007-04-19 18:18:57 | Re: Can Postgresql be ported to a device with no OS and simple file I/O and memory management? |
| Previous Message | Alvaro Herrera | 2007-04-19 16:56:44 | Re: Postgres data/form entry tool |