From 25d8209fdf7a4d1f04f4893dcf904cc906a8ffcf Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 31 Mar 2016 20:40:49 -0400 Subject: [PATCH] LP#1549505: Filter publication years to the current year and before to avoid junk data Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index ae9e3a722b..d6e5a22a09 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -887,7 +887,8 @@ BEGIN s.source = pop.id AND s.attr = 'pubdate' AND s.value ~ '^\d+$' - ); + ) + WHERE s.value::INT <= EXTRACT(YEAR FROM NOW())::INT; END; $f$ LANGUAGE PLPGSQL STRICT; -- 2.11.0