Re: FTS on patterns

Lists: pgsql-general
From: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
To: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: FTS on patterns
Date: 2008-08-05 14:03:15
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

Hello,

In our application we need a pattern based text search, that is if user
supplies 'foo bar' he receives only documents containing words that begin
with 'foo' or 'bar', including themselves (something similar to MySQL '+foo*
+bar*' text search query). Currently we use separate table for unique words
in document and do LIKE 'foo%' search on that table, combining the results
afterwards, and I am not really happy with that solution because of its
speed and overcomplication of the queries involved. Does anyone know of a
better approach? Could this be achieved with Postgres full text search?

From: Felipe de Jesús Molina Bravo <felipe(dot)molina(at)inegi(dot)gob(dot)mx>
To: Vyacheslav Kalinin <vka(at)mgcp(dot)com>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: FTS on patterns
Date: 2008-08-05 14:23:28
Message-ID: 1217946209.4369.4.camel@fjmb
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

tsearch can help you; i have a system with it ... and its ok.

El mar, 05-08-2008 a las 18:03 +0400, Vyacheslav Kalinin escribió:
> Hello,
>
> In our application we need a pattern based text search, that is if
> user supplies 'foo bar' he receives only documents containing words
> that begin with 'foo' or 'bar', including themselves (something
> similar to MySQL '+foo* +bar*' text search query). Currently we use
> separate table for unique words in document and do LIKE 'foo%' search
> on that table, combining the results afterwards, and I am not really
> happy with that solution because of its speed and overcomplication of
> the queries involved. Does anyone know of a better approach? Could
> this be achieved with Postgres full text search?
>
>
>

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: FTS on patterns
Date: 2008-08-05 14:53:53
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

"Vyacheslav Kalinin" <vka(at)mgcp(dot)com> writes:
> In our application we need a pattern based text search, that is if user
> supplies 'foo bar' he receives only documents containing words that begin
> with 'foo' or 'bar'

There's support for prefix text search in CVS HEAD, but not in any
released version ...

regards, tom lane

From: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: FTS on patterns
Date: 2008-08-06 00:25:59
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

On Tue, Aug 5, 2008 at 6:53 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>
> There's support for prefix text search in CVS HEAD, but not in any
> released version ...
>
> regards, tom lane
>

Oh, does that mean it won't be released until 8.4?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Vyacheslav Kalinin <vka(at)mgcp(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: FTS on patterns
Date: 2008-08-06 08:03:34
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Lists: pgsql-general

Vyacheslav Kalinin wrote:
> On Tue, Aug 5, 2008 at 6:53 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> There's support for prefix text search in CVS HEAD, but not in any
>> released version ...
>>
>> regards, tom lane
>
> Oh, does that mean it won't be released until 8.4?

New features are never introduced in minor releases (8.3.x) only bugfixes.

--
Richard Huxton
Archonet Ltd