Re: [SQL] sort by relevance

2003-01-15 Thread Rajesh Kumar Mallah.
Yet another customer for relevence ranking ;-) malz. On Wednesday 15 January 2003 11:49 pm, Oleg Bartunov wrote: > On Wed, 15 Jan 2003 [EMAIL PROTECTED] wrote: > > HI, PPL! > > > > How am I able to sort query results by relevance? > > I use contrib/tsearch to search using fill text index! > > Us

Re: [SQL] sort by relevance

2003-01-15 Thread sector119
On Wed, Jan 15, 2003 at 09:19:47PM +0300, Oleg Bartunov wrote: > On Wed, 15 Jan 2003 [EMAIL PROTECTED] wrote: > > > HI, PPL! > > > > How am I able to sort query results by relevance? > > I use contrib/tsearch to search using fill text index! > > > > Use OpenFTS (openfts.sourceforge.net) for relev

Re: [SQL] sort by relevance

2003-01-15 Thread Ross J. Reedstrom
On Wed, Jan 15, 2003 at 09:19:47PM +0300, Oleg Bartunov wrote: > On Wed, 15 Jan 2003 [EMAIL PROTECTED] wrote: > > > HI, PPL! > > > > How am I able to sort query results by relevance? > > I use contrib/tsearch to search using fill text index! > > > > Use OpenFTS (openfts.sourceforge.net) for relev

Re: [SQL] sort by relevance

2003-01-15 Thread Oleg Bartunov
On Wed, 15 Jan 2003 [EMAIL PROTECTED] wrote: > HI, PPL! > > How am I able to sort query results by relevance? > I use contrib/tsearch to search using fill text index! > Use OpenFTS (openfts.sourceforge.net) for relevance ranking. we might add relevance feature to tsearch though. > Rega

[SQL] sort by relevance

2003-01-15 Thread sector119
HI, PPL! How am I able to sort query results by relevance? I use contrib/tsearch to search using fill text index! -- WBR, sector119 msg09000/pgp0.pgp Description: PGP signature

[SQL] Sort by relevance

2001-01-15 Thread Chad McKay
Hello,I am trying to use a perl script to break an input string into keywords andpull out all the records that match any of them:my (@chips)= split(' ', $f_name);foreach my $chip (@chips) {    next if ($stoppers=~/ $chip / || length($chip) < 3);    if ($query) {$query .= " OR name ~* '.*$chi