X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=8de801a0f617b940ad98ea43b36f775411c386cf;hp=5c1174b904be992ab23329e7ce360ccba00a3ae0;hb=f2e7bdde075dbdb50547dfe06ad3d5b1765f4106;hpb=8a2e714085d823872527e19fddcdee6e1ca54e34 diff --git a/sql/base/base.sql b/sql/base/base.sql index 5c1174b..8de801a 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -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'));