Postgres Pro
Downloads
Home   >   mailing lists

Thread: Soundex functions for triggers?

Soundex functions for triggers?

From
"Roderick A. Anderson"
Date:
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

Re: [GENERAL] Soundex functions for triggers?

From
Rob Walker
Date:

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

Re: [GENERAL] Soundex functions for triggers?

From
Bruce Momjian
Date:
/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