Re: tsearch partial word

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Yudie Pg <yudiepg(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch partial word
Date: 2006-04-17 20:56:16
Message-ID: 444400F0.5030807@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tsearch doesn't support such scan. You can add your own operation or modify
existing, but in any case index will not support it.

I don't known efficient index structure for queries you need...

Yudie Pg wrote:
> Is it possible to search partial word as *like '%...%'* in tsearch?
>
> Yudie

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2006-04-17 23:13:55 Re: catch SQLException, error code for Foeign key violation,
Previous Message felix 2006-04-17 20:52:40 Re: Query runs fast or slow