[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

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. Regards,

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 relevance ranking.

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 relevance ranking.

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! Use OpenFTS

[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 ~* '.*$chip.*'