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');
Elie Nacache
Vinay Jain <vinayjain@gmail.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.