How to write soundex query in postgresql??

Vinay Jain wrote:
[color=blue]
> Hi
> I want to write soundex query for example:
> select * from student where name soundex 'vinay';
> In psql it gives error at soundex.[/color]

The /contrib module fuzzystrmatch has a soundex() function. I
haven't used it though...

Mike Mascari



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Vinay Jain wrote:[color=blue]
> Hi
> I want to write soundex query for example:
> select * from student where name soundex 'vinay';
> In psql it gives error at soundex.[/color]

Where did you find documentation on a "soundex" operator?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to Join Bytes!

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/artic...cle.asp?p=24691

Good luck
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.