From 655a55bb9d493abc247049261b38a97bd7261fdb Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 2 Aug 2012 14:40:05 -0400 Subject: [PATCH] fix bib query so that each bib is extracted only once Signed-off-by: Galen Charlton --- collectionHQ/functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/collectionHQ/functions.sql b/collectionHQ/functions.sql index 92ed5f1..1c80328 100644 --- a/collectionHQ/functions.sql +++ b/collectionHQ/functions.sql @@ -195,7 +195,7 @@ CREATE OR REPLACE FUNCTION collectionHQ.write_bib_rows_to_stdout (TEXT, INT) RET BEGIN FOR lms_bib_id IN - EXECUTE ('SELECT bre.id FROM biblio.record_entry bre JOIN asset.call_number acn ON (acn.record = bre.id) WHERE acn.owning_lib IN (SELECT id FROM actor.org_unit_descendants(' || org_unit_id || ')) AND NOT acn.deleted AND NOT bre.deleted;') + EXECUTE ('SELECT DISTINCT bre.id FROM biblio.record_entry bre JOIN asset.call_number acn ON (acn.record = bre.id) WHERE acn.owning_lib IN (SELECT id FROM actor.org_unit_descendants(' || org_unit_id || ')) AND NOT acn.deleted AND NOT bre.deleted;') LOOP EXECUTE (E'SELECT isbn[1] FROM reporter.materialized_simple_record r WHERE r.id = ' || lms_bib_id || ';') INTO isbn; -- 2.11.0