From 6fb1cdcd32b157a99d9f8ce8d16ed4d1adf2bf24 Mon Sep 17 00:00:00 2001 From: berick Date: Thu, 21 Apr 2011 13:52:49 -0400 Subject: [PATCH] repaired some thinko's in vandelay.match_bib_record stored proc --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index c6b73708c6..25e3f4ca99 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -508,10 +508,11 @@ BEGIN incoming_existing_id := oils_xpath_string('//*[@tag="901"]/*[@code="c"][1]',NEW.marc); - IF incoming_existing_id IS NOT NULL THEN - SELECT id INTO tmp_rec FROM biblio.record_entry WHERE id = exact_id; + IF incoming_existing_id IS NOT NULL AND incoming_existing_id != '' THEN + incoming_existing_id := incoming_existing_id::bigint; + SELECT id INTO tmp_rec FROM biblio.record_entry WHERE id = incoming_existing_id; IF tmp_rec IS NOT NULL THEN - INSERT INTO vandelay.bib_match (queued_record, eg_record, quality) VALUES ( NEW.id, exact_id, 9999); + INSERT INTO vandelay.bib_match (queued_record, eg_record, quality) VALUES ( NEW.id, incoming_existing_id, 9999); RETURN NEW; END IF; END IF; -- 2.11.0