From 5995b0da11ea2bb50ce79a8df2b6dfe065adb0eb Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Mon, 25 Jul 2011 16:39:07 -0400 Subject: [PATCH] Extraneous semicolons break SQL Remove them so that cache_copy_visibility can function. Signed-off-by: Thomas Berezansky Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/999.functions.global.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index a75a635392..f44dd17416 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -1325,14 +1325,14 @@ BEGIN ELSIF NEW.opac_visible THEN -- add rows IF TG_TABLE_NAME = 'org_unit' THEN - add_base_query := add_base_query || ' AND cp.circ_lib = ' || NEW.id || ';'; - add_peer_query := add_peer_query || ' AND cp.circ_lib = ' || NEW.id || ';'; + add_base_query := add_base_query || ' AND cp.circ_lib = ' || NEW.id; + add_peer_query := add_peer_query || ' AND cp.circ_lib = ' || NEW.id; ELSIF TG_TABLE_NAME = 'copy_location' THEN - add_base_query := add_base_query || ' AND cp.location = ' || NEW.id || ';'; - add_peer_query := add_peer_query || ' AND cp.location = ' || NEW.id || ';'; + add_base_query := add_base_query || ' AND cp.location = ' || NEW.id; + add_peer_query := add_peer_query || ' AND cp.location = ' || NEW.id; ELSIF TG_TABLE_NAME = 'copy_status' THEN - add_base_query := add_base_query || ' AND cp.status = ' || NEW.id || ';'; - add_peer_query := add_peer_query || ' AND cp.status = ' || NEW.id || ';'; + add_base_query := add_base_query || ' AND cp.status = ' || NEW.id; + add_peer_query := add_peer_query || ' AND cp.status = ' || NEW.id; END IF; EXECUTE add_front || add_base_query || ' UNION ' || add_peer_query || add_back; -- 2.11.0