Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6C947477131; Wed, 15 Jan 2003 14:12:49 -0500 (EST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by postgresql.org (Postfix) with ESMTP id CE075477436; Wed, 15 Jan 2003 13:19:50 -0500 (EST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.9.3/8.9.3) with ESMTP id VAA28576; Wed, 15 Jan 2003 21:19:47 +0300 (MSK) Date: Wed, 15 Jan 2003 21:19:47 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: sector119@mail.ru Cc: pgsql-sql@postgresql.org, Subject: Re: [SQL] sort by relevance In-Reply-To: <20030115135817.GA16359@city.gov.te.ua> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/570 X-Sequence-Number: 35691 On Wed, 15 Jan 2003 sector119@mail.ru 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: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83