From 7ef64e6f9f0ec07bc5fc53aa54bf93540abfd4cf Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 5 Apr 2011 11:26:42 -0400 Subject: [PATCH] syntax --- Open-ILS/src/sql/Pg/999.functions.global.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index 954f6728a0..30cf0e8f34 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -1209,7 +1209,7 @@ BEGIN EXECUTE add_query; RETURN NEW; ELSE - remove_query := 'DELETE FROM asset.opac_visible_copies WHERE copy_id ' || OLD.target_copy || ' AND record = ' || OLD.peer_record || ';'; + remove_query := 'DELETE FROM asset.opac_visible_copies WHERE copy_id = ' || OLD.target_copy || ' AND record = ' || OLD.peer_record || ';'; EXECUTE remove_query; RETURN OLD; END IF; -- 2.11.0