Re: [GENERAL] Soundex functions for triggers? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] Soundex functions for triggers?
Date
Msg-id 199903151850.NAA18268@candle.pha.pa.us
Whole thread Raw
In response to Soundex functions for triggers?  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-general
/pgsql/contrib/soundex.

> I live in an area with a lot of early French explorer influence therefore
> may french names.  I'm building a database for a website/directory of
> businesses, organizations, attractions, etc. for the locals and visitors.
> I'd like to handle miss-spellings or rather phonetic spellings for those
> that have heard of Core da Lane but don't realize it's spelled Coeur
> d'Alene.
>    I remember reading of a set of functions that convert words and phrases
> into soundex thingy's.  Using this set of functions I'd store a soundex
> thingy so searches could be on this instead of the actual name.
>
> Is anyone on the list aware of someone building these functions so they
> are usable in triggers? (Of course I'm now thinking I've seen mention of
> soundex being a part of PostgreSQL.  Go figure!)
>    Any pointers or suggestions are greatly appreciated.
>
> Rod
> --
> Roderick A. Anderson
> raanders@altoplanos.net               Altoplanos Information Systems, Inc.
> Voice: 208.765.6149                            212 S. 11th Street, Suite 5
> FAX: 208.664.5299                                  Coeur d'Alene, ID 83814
>
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "James Puckett"
Date:
Subject: RE: [GENERAL] postgres and PERL
Next
From: "Jonathan A. Zdziarski"
Date:
Subject: Solaris 7 Compile Errors