From e4d2843cf356364b515e0f4f34037f3062d25cd6 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 16 Aug 2019 12:57:23 -0400 Subject: [PATCH] get_marc_tag: return null if field not found Signed-off-by: Jason Etheridge --- sql/base/base.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index a9b436b..9f3c6c9 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -3823,7 +3823,8 @@ CREATE OR REPLACE FUNCTION migration_tools.get_marc_tag (TEXT, TEXT, TEXT, TEXT) my $marc = MARC::Record->new_from_xml($marcxml, 'UTF-8'); $field = $marc->field($tag); }; - return $field->as_string($subfield,$delimiter); + return $field->as_string($subfield,$delimiter) if $field; + return; $$ LANGUAGE PLPERLU STABLE; CREATE OR REPLACE FUNCTION migration_tools.get_marc_tags (TEXT, TEXT, TEXT, TEXT) RETURNS TEXT[] AS $$ -- 1.7.2.5