pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

fuzzy search
2+ messages / 2 participants
[nested] [flat]

* fuzzy search
@ 2008-08-02 10:48  giuseppe.derossi@email.it
  0 siblings, 1 reply; 2+ messages in thread

From: giuseppe.derossi@email.it @ 2008-08-02 10:48 UTC (permalink / raw)
  To: pgsql-admin


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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: fuzzy search
@ 2008-08-02 15:25  Tom Lane <tgl@sss.pgh.pa.us>
  parent: giuseppe.derossi@email.it
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-08-02 15:25 UTC (permalink / raw)
  To: giuseppe.derossi@email.it; +Cc: pgsql-admin

giuseppe.derossi@email.it writes:
> I'd like to know if there is a way to retrieve similar results by a fuzzy
> search.

There's some functions in contrib/fuzzystrmatch that might help ...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-08-02 15:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-02 10:48 fuzzy search giuseppe.derossi@email.it
2008-08-02 15:25 ` Tom Lane <tgl@sss.pgh.pa.us>

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