Thread

1. /contrib/soundex doesn't work. Version 7.0.2

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-09-29T05:57:25Z

   Edmar Wiggers (edmarw@yahoo.com) reports a bug with a severity of 2
   The lower the number the more severe it is.
   
   Short Description
   /contrib/soundex doesn't work. Version 7.0.2
   
   Long Description
   The code in /contrib/soundex doesn't work. It does compile though. I create the function in the database, but it always returns nothing (blank)!
   
   It should be a small stupid mistake in the source code. I bet you can fix it within 5 minutes (as opposed to me, who would take about 5 hours). If you can look into it, please drop me a line.
   
   
   Sample Code
   
   
   No file was uploaded with this report
   
   
   

2. Re: /contrib/soundex doesn't work. Version 7.0.2

   Peter Eisentraut <peter_e@gmx.net> — 2000-09-29T14:51:51Z

   pgsql-bugs@postgresql.org writes:
   
   > The code in /contrib/soundex doesn't work. It does compile though. I
   > create the function in the database, but it always returns nothing
   > (blank)!
   
   Hmm, while I can confirm that the soundex algorithm is implemented
   incorrectly I never get blanks only.  Check that you have defined the
   function like this:
   
       CREATE FUNCTION soundex(text) RETURNS text AS
         '/some/where/soundex.so', 'text_soundex' LANGUAGE 'C';
   
   (ignore the stuff in soundex.sql, it's broken).
   
   To get a correct implementation of soundex, apply the attached patch.  
   You need to restart the server to get it to load the new object file.
   
   Also note that there is a disagreement among experts over one particular
   part of the algorithm.  Check it out with your favourite search engine.
   
   
   -- 
   Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/