From 573fe2a274a78a07b767e158d065782d1aec2ca6 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 2 Jul 2008 02:19:25 +0000 Subject: [PATCH] update the currently indexed data to handle birth/death date stemming consistently git-svn-id: svn://svn.open-ils.org/ILS/trunk@9955 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../src/sql/Pg/1.2.2.1-1.2.2.2-upgrade-db.sql | 24 +++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.2.2.1-1.2.2.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.2.1-1.2.2.2-upgrade-db.sql index eb47a0011f..fc410a86aa 100644 --- a/Open-ILS/src/sql/Pg/1.2.2.1-1.2.2.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.2.1-1.2.2.2-upgrade-db.sql @@ -30,5 +30,29 @@ CREATE VIEW extend_reporter.full_circ_count AS LEFT JOIN "action".circulation circ ON circ.target_copy = c.id GROUP BY cp.id; +UPDATE metabib.title_field_entry + SET value = REGEXP_REPLACE(value, E'(\\d{4})-(\\d{4})', E'\\1 \\2','g') + WHERE value ~ E'(\\d{4})-(\\d{4})'; + +UPDATE metabib.author_field_entry + SET value = REGEXP_REPLACE(value, E'(\\d{4})-(\\d{4})', E'\\1 \\2','g') + WHERE value ~ E'(\\d{4})-(\\d{4})'; + +UPDATE metabib.keyword_field_entry + SET value = REGEXP_REPLACE(value, E'(\\d{4})-(\\d{4})', E'\\1 \\2','g') + WHERE value ~ E'(\\d{4})-(\\d{4})'; + +UPDATE metabib.subject_field_entry + SET value = REGEXP_REPLACE(value, E'(\\d{4})-(\\d{4})', E'\\1 \\2','g') + WHERE value ~ E'(\\d{4})-(\\d{4})'; + +UPDATE metabib.series_field_entry + SET value = REGEXP_REPLACE(value, E'(\\d{4})-(\\d{4})', E'\\1 \\2','g') + WHERE value ~ E'(\\d{4})-(\\d{4})'; + +UPDATE metabib.full_rec + SET value = REGEXP_REPLACE(value, E'(\\d{4})-(\\d{4})', E'\\1 \\2','g') + WHERE value ~ E'(\\d{4})-(\\d{4})'; + COMMIT; -- 2.43.2