From 19c94b139ae66b6440a01cb6d53def7939777690 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 17 Jan 2014 16:16:23 -0500 Subject: [PATCH] Make extra sure there is no empty data Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.MVF.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.MVF.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.MVF.sql index e33938551b..5d04b527b6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.MVF.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.MVF.sql @@ -369,7 +369,7 @@ END; $func$ LANGUAGE PLPGSQL; CREATE TEMP TABLE attr_set ON COMMIT DROP AS SELECT DISTINCT id AS source, (each(attrs)).key,(each(attrs)).value FROM metabib.record_attr; -UPDATE attr_set SET source = NULL WHERE BTRIM(value) = ''; +DELETE FROM attr_set WHERE BTRIM(value) = ''; -- Grab sort values for the new sorting mechanism INSERT INTO metabib.record_sorter (source,attr,value) -- 2.11.0