soundex - usage

soundex - usage

Post by nall » Wed, 30 Aug 2000 04:00:00



Actually what is the use of soundex method?
can u give one example
 
 
 

soundex - usage

Post by Bob Pfeif » Thu, 31 Aug 2000 04:00:00


It compares two strings for similarity.  Try this:

use pubs

select
 *
from
 authors
where
 soundex(au_lname) =soundex('benet')

 
 
 

1. pgsql/contrib/soundex (soundex.c soundex.sql.in)


Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/contrib/soundex
     from hub.org:/home/projects/pgsql/tmp/cvs-serv51753/contrib/soundex

Modified Files:
        soundex.c soundex.sql.in

-----------------------------  Log Message  -----------------------------

Revise handling of oldstyle/newstyle functions per recent discussions
in pghackers list.  Support for oldstyle internal functions is gone
(no longer needed, since conversion is complete) and pg_language entry
'internal' now implies newstyle call convention.  pg_language entry
'newC' is gone; both old and newstyle dynamically loaded C functions
are now called language 'C'.  A newstyle function must be identified
by an associated info routine.  See src/backend/utils/fmgr/README.

2. Mr.Fred ,would you like help me again?

3. select soundex(string1), soundex(string2)

4. Re-compile Stored Procedures

5. pgsql/contrib/soundex (soundex.c)

6. # of rows in all tables.

7. Usage Analysis / Usage Optimization Error

8. CPU usage in Oracle 7.3.3

9. ADO Causes 100% Memory Usage/Increases in VM Usage

10. Index Space Usage more than Data Space Usage

11. SOUNDEX Performance

12. Soundex and "look-alike" searches

13. SOUNDEX