From: giuseppe.derossi@email.it
To: pgsql-admin@postgresql.org
Subject: fuzzy search
Date: Sat, 2 Aug 2008 12:48:11 +0200
Message-ID: <eee12216ba96084ec138f1b3da83a1f7@87.11.84.115> (raw)
Hi,
I've to retrieve some addresses from a "dirty" database, sometimes the same
address is written in such a different way for axample:
george washington avenue n 44
I can find:
g. washington avenue
washington avenue
g. washington av.
wHashington avAnue ( in case of error)
etc.
I'd like to know if there is a way to retrieve similar results by a fuzzy
search.
Thanks in advance
Giu
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Impazzisci per Vasco? Scarica ora il mondo che vorrei sul cellulare
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7750&d=20080802
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: giuseppe.derossi@email.it
Subject: Re: fuzzy search
In-Reply-To: <eee12216ba96084ec138f1b3da83a1f7@87.11.84.115>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox