projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
8a2e714
)
overzealous heuristic
author
Jason Etheridge
<jason@esilibrary.com>
Wed, 8 Nov 2017 02:06:55 +0000 (21:06 -0500)
committer
Jason 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
patch
|
blob
|
history
diff --git
a/sql/base/base.sql
b/sql/base/base.sql
index
5c1174b
..
8de801a
100644
(file)
--- 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'));