Обсуждение: 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