hold mediation syntax repairs
authorBill Erickson <berick@esilibrary.com>
Tue, 11 Feb 2014 18:40:50 +0000 (13:40 -0500)
committerBill Erickson <berick@esilibrary.com>
Tue, 11 Feb 2014 18:40:50 +0000 (13:40 -0500)
Signed-off-by: Bill Erickson <berick@esilibrary.com>

Open-ILS/src/sql/Pg/fulfillment-mods.sql

index ec9e5bf..a34a151 100644 (file)
@@ -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;