Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B0482477131; Wed, 22 Jan 2003 17:30:52 -0500 (EST) Received: from ns1.gnw.de (ns1.turtle-entertainment.de [193.41.200.20]) by postgresql.org (Postfix) with ESMTP id 9974B4771C5; Wed, 22 Jan 2003 16:46:32 -0500 (EST) Received: from [213.148.158.226] (helo=mail.office.turtle-entertainment.de) by ns1.gnw.de with esmtp (Exim 3.16 #1 (Debian)) id 18bSeZ-00082S-00; Wed, 22 Jan 2003 22:43:23 +0100 Received: from pd9e212e9.dip.t-dialin.net ([217.226.18.233] helo=shock) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 18bSeQ-0001Ov-00; Wed, 22 Jan 2003 22:43:14 +0100 Message-ID: <012b01c2c25f$407d2460$0564a8c0@shock> From: =?iso-8859-1?Q?Bj=F6rn_Metzdorf?= To: "Serhiy Levchenko" , , References: <3E251148.8090707@city.gov.te.ua> Subject: Re: sort by relevance Date: Wed, 22 Jan 2003 22:43:05 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Scanner: exiscan *18bSeQ-0001Ov-00*nnQA0QBz4ss* http://duncanthrax.net/exiscan/ X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/885 X-Sequence-Number: 36006 > How am I able to sort query results by relevance? > I use contrib/tsearch to search using fill text index! I think you need to use OpenFTS (openfts.sf.net). tsearch does not provide relevance ranking at this time. Regards, Bjoern