Soundex functions for triggers?
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
On Mon, 15 Mar 1999, Roderick A. Anderson wrote:
...
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
Try looking in the contrib/soundex directory of the distribution (I'm
using 6.4.2)
I have done a similar thing using triggers and it works fine. I can't
get at the code right now, but email me if you want it.
Rob
/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