pgsql: Add support for Daitch-Mokotoff Soundex in contrib/fuzzystrmatch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add support for Daitch-Mokotoff Soundex in contrib/fuzzystrmatch
Date: 2023-04-07 21:32:35
Message-ID: E1pkthB-001vRa-Vv@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add support for Daitch-Mokotoff Soundex in contrib/fuzzystrmatch.

This modernized version of Soundex works significantly better than
the original, particularly for non-English names.

Dag Lem, reviewed by quite a few people along the way

Discussion: https://postgr.es/m/yger1atbgfy.fsf@sid.nimrod.no

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a290378a3752f787cdc2252889ba513f6fb393db

Modified Files
--------------
contrib/fuzzystrmatch/.gitignore | 2 +
contrib/fuzzystrmatch/Makefile | 20 +-
contrib/fuzzystrmatch/daitch_mokotoff.c | 577 +++++++++++++++++++++
contrib/fuzzystrmatch/daitch_mokotoff_header.pl | 223 ++++++++
contrib/fuzzystrmatch/expected/fuzzystrmatch.out | 171 ++++++
.../fuzzystrmatch/expected/fuzzystrmatch_utf8.out | 61 +++
.../expected/fuzzystrmatch_utf8_1.out | 8 +
contrib/fuzzystrmatch/fuzzystrmatch--1.1--1.2.sql | 8 +
contrib/fuzzystrmatch/fuzzystrmatch.control | 2 +-
contrib/fuzzystrmatch/meson.build | 14 +-
contrib/fuzzystrmatch/sql/fuzzystrmatch.sql | 45 ++
contrib/fuzzystrmatch/sql/fuzzystrmatch_utf8.sql | 26 +
doc/src/sgml/fuzzystrmatch.sgml | 169 +++++-
13 files changed, 1315 insertions(+), 11 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2023-04-07 22:17:27 pgsql: Adjust contrib/sepgsql regression test expected outputs.
Previous Message Andres Freund 2023-04-07 21:08:56 pgsql: Fix table name clash in recently introduced test