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 8EB3FD1B584 for ; Fri, 21 Nov 2003 20:19:47 +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 77680-08 for ; Fri, 21 Nov 2003 16:19:17 -0400 (AST) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id DEBFDD1B4E6 for ; Fri, 21 Nov 2003 16:19:07 -0400 (AST) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id hALKI5eF026955; Fri, 21 Nov 2003 23:18:05 +0300 (MSK) Date: Fri, 21 Nov 2003 23:18:05 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Ian Barwick Cc: Christoph Haller , Gulshan Babajee , pgsql-sql@postgresql.org Subject: Re: Compare strings which resembles each other In-Reply-To: <200311212037.12206.barwick@gmx.net> Message-ID: References: <200311211422.PAA13790@rodos> <200311212037.12206.barwick@gmx.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/268 X-Sequence-Number: 16083 On Fri, 21 Nov 2003, Ian Barwick wrote: > 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. It's don't released because of lack of documentation :( It's tested and used in production. I'll send you archive in separate message. > > Ian Barwick > barwick@gmx.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > 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