From f1ec081cd78dff72775a606bb72edcf7a39e4565 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 1 Apr 2011 13:49:00 -0400 Subject: [PATCH] no semicolon before UNION --- 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 f3944f7646..391949124f 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -1142,7 +1142,7 @@ CREATE OR REPLACE FUNCTION asset.refresh_opac_visible_copies_mat_view () RETURNS AND cs.opac_visible AND cl.opac_visible AND cp.opac_visible - AND a.opac_visible; + AND a.opac_visible UNION SELECT cp.id, cp.circ_lib, pbcm.peer_record AS record FROM asset.copy cp -- 2.11.0