X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 02365D1CCE0 for ; Fri, 21 Nov 2003 19:38:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71195-06 for ; Fri, 21 Nov 2003 15:37:34 -0400 (AST) Received: from p15140235.pureserver.info (sql-info.de [217.160.166.164]) by svr1.postgresql.org (Postfix) with ESMTP id A1E82D1C96C for ; Fri, 21 Nov 2003 15:37:32 -0400 (AST) Received: by p15140235.pureserver.info (Postfix, from userid 639) id EB20E203A; Fri, 21 Nov 2003 20:37:16 +0100 (CET) Received: from iwate.sql-info.de (pD9517D1D.dip.t-dialin.net [217.81.125.29]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by p15140235.pureserver.info (Postfix) with ESMTP id CB8C5132A; Fri, 21 Nov 2003 20:37:14 +0100 (CET) From: Ian Barwick To: Oleg Bartunov , Christoph Haller Subject: Re: Compare strings which resembles each other Date: Fri, 21 Nov 2003 20:37:12 +0100 User-Agent: KMail/1.5.1 Cc: Gulshan Babajee , pgsql-sql@postgresql.org References: <200311211422.PAA13790@rodos> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200311212037.12206.barwick@gmx.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/267 X-Sequence-Number: 16082 On Friday 21 November 2003 15:32, Oleg Bartunov wrote: > On Fri, 21 Nov 2003, Christoph Haller wrote: > > $PGSQLD/contrib/tsearch/README.tsearch > > is your friend. > > I think tsearch(2) isn't what Gulshan need. He needs fuzzy search, > there are several modules in contrib directory (metaphone, fuzzystrmatch). > Also, we have trgm module which uses trigram and has index support. Hi Oleg, do you have any more information on trgm? According to your website it isn't released. I am looking for something along those lines and might be able to assist, at least with testing and documentation. Ian Barwick barwick@gmx.net