Soundex functions for triggers?
От | Roderick A. Anderson |
---|---|
Тема | Soundex functions for triggers? |
Дата | |
Msg-id | Pine.LNX.3.95.990315073250.10754A-100000@altoplanos.net обсуждение исходный текст |
Ответы |
Re: [GENERAL] Soundex functions for triggers?
Re: [GENERAL] Soundex functions for triggers? |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: