Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2816947668B; Wed, 15 Jan 2003 16:00:34 -0500 (EST) Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (Postfix) with ESMTP id CF19747725C; Wed, 15 Jan 2003 15:07:42 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with SMTP id 70DA368AA2; Wed, 15 Jan 2003 14:07:43 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id 2068868A88; Wed, 15 Jan 2003 14:07:43 -0600 (CST) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 5099068A86; Wed, 15 Jan 2003 14:07:42 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.36 #1 (Debian)) id 18Ytp8-0007dZ-00; Wed, 15 Jan 2003 14:07:42 -0600 Date: Wed, 15 Jan 2003 14:07:41 -0600 From: "Ross J. Reedstrom" To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: sort by relevance Message-ID: <20030115200741.GA29352@wallace.ece.rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , pgsql-sql@postgresql.org, pgsql-general@postgresql.org References: <20030115135817.GA16359@city.gov.te.ua> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS snapshot-20020300 X-DCC--Metrics: ece.rice.edu 1066; Body=1 Fuz1=1 Fuz2=1 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/236 X-Sequence-Number: 11101 On Wed, Jan 15, 2003 at 09:19:47PM +0300, Oleg Bartunov wrote: > 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. Here's another tsearch 'customer' who'd love that feature. Ross