From eb798340c4d9017020020ddeda230e5579b253fa Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 18 Jul 2008 14:59:07 +0000 Subject: [PATCH] protect against "no bump for type" git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2_2@10073 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) 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 9aca3fbbe6..2063482eef 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -209,8 +209,10 @@ BEGIN END IF; - current_rank := current_rank || ' * ( CASE WHEN ' || tmp_text || - ' THEN ' || rank_adjust.multiplier || '::REAL ELSE 1.0 END )'; + IF tmp_text IS NOT NULL THEN + current_rank := current_rank || ' * ( CASE WHEN ' || tmp_text || + ' THEN ' || rank_adjust.multiplier || '::REAL ELSE 1.0 END )'; + END IF; used_ranks := array_append( used_ranks, rank_adjust.bump_type ); -- 2.11.0