From b89fafd6a0baa8168308e7e05e6d47ee1540f658 Mon Sep 17 00:00:00 2001 From: berick Date: Wed, 4 May 2011 10:45:40 -0400 Subject: [PATCH] don't match on deleted bib records --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index ce1852751d..9d14678469 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -539,7 +539,7 @@ BEGIN FROM _vandelay_tmp_jrows; -- add those joins and the where clause to our query. - query_ := query_ || joins || E'\n' || 'WHERE ' || wq; + query_ := query_ || joins || E'\n' || 'WHERE ' || wq || ' AND not bre.deleted'; -- this will return rows of record,quality FOR rec IN EXECUTE query_ USING tags_rstore, svf_rstore LOOP -- 2.11.0