SOUNDEX - plans for SQL function?

SOUNDEX - plans for SQL function?

Post by Kym Farni » Tue, 26 Mar 2002 10:07:06



Hi - Are there any plans for SOUNDEX SQL function
in the future?   I'm happy to donate a Java
package that implements SOUNDEX if required.


-- Recall Design     http://www.recalldesign.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

 
 
 

SOUNDEX - plans for SQL function?

Post by Dan Langill » Tue, 26 Mar 2002 10:27:31



Quote:> Hi - Are there any plans for SOUNDEX SQL function
> in the future?

There is something in the contrib directory.  For details on how I put
that into my database, see http://www.freebsddiary.org/postgresql-7.2.php
and look for the section titled "Soundex/Fuzzy matching".

[yes, it's FreeBSD-centric, but the basic instructions should get you
going under any other OS]
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

 
 
 

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. max async IO

3. MS SQL Soundex function

4. pgsql-server/src backend/storage/lmgr/s_lock.c ...

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

6. SMI table feature request

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

8. SOS: locked rows are blocking table read !?

9. SOUNDEX Function

10. Soundex function

11. Function for SOUNDEX

12. Soundex and difference functions for UNICODE chars