From: Jason Etheridge Date: Fri, 16 Aug 2019 16:57:23 +0000 (-0400) Subject: get_marc_tag: return null if field not found X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=e4d2843cf356364b515e0f4f34037f3062d25cd6 get_marc_tag: return null if field not found Signed-off-by: Jason Etheridge --- 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 $$