From 139307a850200efab10e2de9a758c2b0ce4e79ab Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 31 May 2008 05:43:37 +0000 Subject: [PATCH] ignore null fingerprints git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_2_2@9746 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Evergreen/src/extras/import/quick_metarecord_map.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Evergreen/src/extras/import/quick_metarecord_map.sql b/Evergreen/src/extras/import/quick_metarecord_map.sql index a402c8668b..89a8364d8a 100644 --- a/Evergreen/src/extras/import/quick_metarecord_map.sql +++ b/Evergreen/src/extras/import/quick_metarecord_map.sql @@ -10,7 +10,8 @@ INSERT INTO metabib.metarecord (fingerprint,master_record) FROM (SELECT DISTINCT ON (fingerprint) fingerprint, id, quality FROM biblio.record_entry - ORDER BY fingerprint, quality desc) AS x; + ORDER BY fingerprint, quality desc) AS x + WHERE fingerprint IS NOT NULL; INSERT INTO metabib.metarecord_source_map (metarecord,source) SELECT m.id, b.id -- 2.11.0