From 16463a0862fb6e5018a7d1b09248975ced7d1f3b Mon Sep 17 00:00:00 2001 From: Josh Stompro Date: Sun, 20 Sep 2015 10:43:10 -0500 Subject: [PATCH] LP#1497318 - Acknowledgments update Adding Northwest Regional Library System to 2.8 and 2.9 and Matthew Berowski for typo fixes to 2.8 Release Notes. Signed-off-by: Josh Stompro --- .../src/sql/Pg/upgrade/XXXX.editable_usr_circ_history.sql | 12 +++--------- 1 file changed, 3 insertions(+), 9 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.editable_usr_circ_history.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.editable_usr_circ_history.sql index 420bee25b7..6303a80f5e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.editable_usr_circ_history.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.editable_usr_circ_history.sql @@ -3,14 +3,8 @@ BEGIN; ALTER TABLE action.circulation ADD COLUMN hide_from_usr_history boolean not null default false; -COMMIT; - -BEGIN; - CREATE OR REPLACE FUNCTION action.usr_visible_circs(usr_id integer) - RETURNS SETOF action.circulation - LANGUAGE plpgsql -AS $function$ + RETURNS SETOF action.circulation AS $function$ DECLARE c action.circulation%ROWTYPE; view_age INTERVAL; @@ -44,11 +38,11 @@ BEGIN AND NOT hide_from_usr_history ORDER BY xact_start DESC LOOP -RETURN NEXT c; + RETURN NEXT c; END LOOP; RETURN; END; -$function$ +$function$ LANGUAGE PLPGSQL; COMMIT; -- 2.11.0