X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=9f3c6c99855999dc00a3ec7d3c7451374e9898f1;hp=a9b436b73c99e95996c77eb50bf55336457cd72f;hb=e4d2843cf356364b515e0f4f34037f3062d25cd6;hpb=2a9f9db6ace09f2a8a541054f41eb7dcbae1fe1a 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 $$