Re: [SQL] sort by relevance
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 (openfts.sourceforge.net) for relevance ranking. > we might add relevance feature to tsearch though. > > > > > Regards, > Oleg > _ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [SQL] sort by relevance
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. Am I able to use OpenFTS if I save data at db or only if I use txt files?? > we might add relevance feature to tsearch though. It would be great to add this feature to tsearch! I need it so much! Wheh we will be able to see this feature at PostgreSQL CVS? :)) -- WBR, sector119 msg09040/pgp0.pgp Description: PGP signature
Re: [SQL] sort by relevance
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. > we might add relevance feature to tsearch though. Here's another tsearch 'customer' who'd love that feature. Ross ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [SQL] sort by relevance
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, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] sort by relevance
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
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.*' ";} else {$query = "SELECT * FROM info WHERE name ~* '.*$chip.*' ";}}this works fine for pulling the records but I would like to sort them by howmany of the "chips" matched.On a set like:name-Bill SmithTed SmithTed Brownan input of : Ted Smithwould give me a query string of: SELECT * FROM info WHERE name ~* '.*Ted.*' or name~*'.*Smith.*'which returns all records - which is what I want - but I would like to haveTed Smith in the first row followed by the other records grouped by name andsorted on another column (city or state in the real table)Thanks for your help,Chad McKay