Postgres Pro
Downloads
Home   >   mailing lists

Re: tsearch partial word - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: tsearch partial word
Date
Msg-id 444400F0.5030807@sigaev.ru
Whole thread Raw
In response to tsearch partial word  ("Yudie Pg" <yudiepg@gmail.com>)
List pgsql-general
Tree view 
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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: felix@crowfix.com
Date:
Subject: Re: Query runs fast or slow
Next
From: Kris Jurka
Date:
Subject: Re: catch SQLException, error code for Foeign key violation,