From e2180f5b26cf0c1bb9055e676b610c3633c47f5c Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 26 Sep 2008 16:50:12 +0000 Subject: [PATCH 1/1] fixing BETWEEN pub date filtering git-svn-id: svn://svn.open-ils.org/ILS/trunk@10708 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 158e16170b..ca63fd69db 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -345,7 +345,7 @@ BEGIN END IF; IF param_between IS NOT NULL AND array_upper(param_between, 1) > 1 THEN - where_clause = where_clause || $$ AND mrd.date1 BETWEEN $$ || array_to_string(param_bib_level, $$' AND '$$) || ' '; + where_clause = where_clause || $$ AND mrd.date1 BETWEEN '$$ || array_to_string(param_between, $$' AND '$$) || $$' $$; END IF; core_rel_query := select_clause || from_clause || where_clause || -- 2.43.2