Re: spelling errors in query terms

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Joel Rodrigues <joelrodrigues(at)ifrance(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: spelling errors in query terms
Date: 2003-12-08 12:09:15
Message-ID: Pine.GSO.4.58.0312081508270.14894@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 8 Dec 2003, Joel Rodrigues wrote:

> Hi,
>
> I seem to recall once coming across & using functionality in PostgreSQL
> that allowed for some flexibility in the spelling of a query term. For
> example, if one meant to look for 'Honda', but typed in 'Zonda'. There
> was even a 'looseness' factor of sorts available. I've spent a lot of
> time trying to find it in the docs and various articles & tutorials on
> my hard drive, even an hour on Google in vain. It was not
> contrib/fuzzystrmatch.

You might try http://www.sai.msu.su/~megera/postgres/gist/trgm/
which uses trigram.

>
> Anyone know what I'm talking about ?
>
> Cheers,
> Joel
>
>
>
>
> _____________________________________________________________________
> Envie de discuter en "live" avec vos amis ? TИlИcharger MSN Messenger
> http://www.ifrance.com/_reloc/m la 1Хre messagerie instantanИe de France
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrei Ivanov 2003-12-08 12:12:40 Re: left join is strange
Previous Message Arjen van der Meijden 2003-12-08 11:23:28 Re: left join is strange