Re: [GENERAL] Soundex functions for triggers?

/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(at)altoplanos(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026