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, 2008 at 10:26 AM, Chris <dmag...@gmail.com> wrote: > 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/ > >