Обсуждение: SOUNDEX

Hello all, I wish to know if there is some function soundex on PostgreSQL ?
I'm need to make search based on this, and by now what I've made was
creating an atribute with the soundex of the name and this soundex was
generated by the php.

Roberto Rezende de Assis <rezende_assis@yahoo.com.br> writes:
> Hello all, I wish to know if there is some function soundex on PostgreSQL ?

Look in the contrib/fuzzystrmatch module.

            regards, tom lane

Roberto Rezende de Assis wrote:
> Hello all, I wish to know if there is some function soundex on PostgreSQL ?
> I'm need to make search based on this, and by now what I've made was
> creating an atribute with the soundex of the name and this soundex was
> generated by the php.

Sure, look in the source tree under contrib/fuzzystrmatch/.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073