END;
$$ LANGUAGE PLPGSQL STRICT VOLATILE;
+CREATE OR REPLACE FUNCTION migration_tools.reset_event (BIGINT) RETURNS VOID AS $$
+ UPDATE
+ action_trigger.event
+ SET
+ start_time = NULL
+ ,update_time = NULL
+ ,complete_time = NULL
+ ,update_process = NULL
+ ,state = 'pending'
+ ,template_output = NULL
+ ,error_output = NULL
+ ,async_output = NULL
+ WHERE
+ id = $1;
+$$ LANGUAGE SQL;
+
CREATE OR REPLACE FUNCTION migration_tools.get_marc_leader (TEXT) RETURNS TEXT AS $$
my ($marcxml) = @_;
if (!defined $ind2) { next; }
if ($ind2 ne '0') { next; }
if (!defined $sfu) { next; }
- if ($sfu =~ m/$matching_u_text/) {
+ if ($sfu =~ m/$matching_u_text/ or $matching_u_text eq 'pineapple') {
$field->add_subfields( '9' => $new_9_to_set );
last;
}