Re: How to write soundex query in postgresql??

Hi Vinary,

One way to implement tolerant search algorithms is to use the soundex algorithm for PostgreSQL, which can be found in the contributed directory of the PostgreSQL source tree.

try SELECT * FROM student WHERE soundex(name)=soundex('vinay');

see http://www.samspublishing.com/articles/article.asp?p=24691

Good luck
Elie Nacache

Vinay Jain <vinayjain(at)gmail(dot)com> wrote:
Hi
I want to write soundex query for example:
select * from student where name soundex 'vinay';
In psql it gives error at soundex.
Regards
Vinay
--
Vinay Jain
Dissertation Project Trainee
DAKE Division
C-DAC Mumbai

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------------
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.