Re: [GENERAL] text_soundex function

Chris wrote: Otandeka Simon Peter wrote: Hi Chris, Tried it and I get LINE 1: SELECT * FROM s WHERE soundex(nm) = soundex('john'); HINT: No function matches the given name and argument types. You might need to add explicit type casts. Ahh, it's a contrib module. It's not installed by defau

Re: [GENERAL] text_soundex function

Otandeka Simon Peter wrote: Hi Chris, Tried it and I get LINE 1: SELECT * FROM s WHERE soundex(nm) = soundex('john'); HINT: No function matches the given name and argument types. You might need to add explicit type casts. Ahh, it's a contrib module. It's not installed by default, it's like

Re: [GENERAL] text_soundex function

Hi Chris, Tried it and I get LINE 1: SELECT * FROM s WHERE soundex(nm) = soundex('john'); HINT: No function matches the given name and argument types. You might need to add explicit type casts. yet the data type of the nm is text. I am using 8.3.1. Anything am doing wrong? On Thu, Dec 18, 20

Re: [GENERAL] text_soundex function

Otandeka Simon Peter wrote: Does this function(text_soundex) exist in the latest Postgresql versions or it was replaced? It's called soundex: http://www.postgresql.org/docs/8.3/interactive/fuzzystrmatch.html -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-genera

[GENERAL] text_soundex function

Does this function(text_soundex) exist in the latest Postgresql versions or it was replaced? Any example on how to use it?