From 9284e9530ac0da1dc063c8b10295a611418a364c Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 18 Jul 2008 15:00:41 +0000 Subject: [PATCH] protect against "no bump for type" git-svn-id: svn://svn.open-ils.org/ILS/trunk@10074 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 8c91ba61b2..b8498d873f 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -191,8 +191,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.43.2