Re: [GENERAL] FTS on patterns

2008-08-06 Thread Richard Huxton
Vyacheslav Kalinin wrote: On Tue, Aug 5, 2008 at 6:53 PM, Tom Lane <[EMAIL PROTECTED]> 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

Re: [GENERAL] FTS on patterns

2008-08-05 Thread Vyacheslav Kalinin
On Tue, Aug 5, 2008 at 6:53 PM, Tom Lane <[EMAIL PROTECTED]> 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?

Re: [GENERAL] FTS on patterns

2008-08-05 Thread Tom Lane
"Vyacheslav Kalinin" <[EMAIL PROTECTED]> 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 v

Re: [GENERAL] FTS on patterns

2008-08-05 Thread Felipe de Jesús Molina Bravo
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

[GENERAL] FTS on patterns

2008-08-05 Thread Vyacheslav Kalinin
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 uniqu