overzealous heuristic
authorJason Etheridge <jason@esilibrary.com>
Wed, 8 Nov 2017 02:06:55 +0000 (21:06 -0500)
committerJason Etheridge <jason@esilibrary.com>
Wed, 8 Nov 2017 02:06:55 +0000 (21:06 -0500)
Signed-off-by: Jason Etheridge <jason@esilibrary.com>

sql/base/base.sql

index 5c1174b..8de801a 100644 (file)
@@ -481,10 +481,6 @@ CREATE OR REPLACE FUNCTION migration_tools.name_parse_out_fuller_last_first_midd
             suffix := 'II';
             temp := BTRIM(REGEXP_REPLACE( temp, E'II', '' ));
         END IF;
-        IF temp like '%IV%' THEN
-            suffix := 'IV';
-            temp := BTRIM(REGEXP_REPLACE( temp, E'IV', '' ));
-        END IF;
 
         IF temp ~ ',' THEN
             family_name = BTRIM(REGEXP_REPLACE(temp,'^(.*?,).*$','\1'));