From 755e2e838815a452687c783f6b13d0506a0cb9a3 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 11 Feb 2014 13:40:50 -0500 Subject: [PATCH] hold mediation syntax repairs Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/fulfillment-mods.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/fulfillment-mods.sql b/Open-ILS/src/sql/Pg/fulfillment-mods.sql index ec9e5bf61d..a34a151468 100644 --- a/Open-ILS/src/sql/Pg/fulfillment-mods.sql +++ b/Open-ILS/src/sql/Pg/fulfillment-mods.sql @@ -100,7 +100,8 @@ $func$ LANGUAGE PLPGSQL; CREATE FUNCTION action.hold_request_mediated () RETURNS TRIGGER AS $f$ BEGIN - SELECT COALESCE(oils_json_to_text(value)::BOOL,FALSE) INTO NEW.frozen FROM actor.org_unit_ancestor_setting('ff.request.force_mediation', NEW.request_lib)); + SELECT COALESCE(oils_json_to_text(value)::BOOL,FALSE) INTO NEW.frozen + FROM actor.org_unit_ancestor_setting('ff.request.force_mediation', NEW.request_lib); RETURN NEW; END; $f$ LANGUAGE PLPGSQL; -- 2.11.0