From d9342c2a67e15baf84fd0208557e30bc4e4d4880 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 14 Mar 2008 20:30:58 +0000 Subject: [PATCH] only using active adjustments git-svn-id: svn://svn.open-ils.org/ILS/trunk@9021 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 2c42d896e8..cb8de81eeb 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -163,7 +163,7 @@ BEGIN END IF; - FOR rank_adjust IN SELECT * FROM search.relevance_adjustment WHERE field IN ( SELECT * FROM search.explode_array( mb_field_list ) ) LOOP + FOR rank_adjust IN SELECT * FROM search.relevance_adjustment WHERE active AND field IN ( SELECT * FROM search.explode_array( mb_field_list ) ) LOOP IF NOT rank_adjust.bump_type = ANY (used_ranks) THEN -- 2.11.0