3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.lpad_number_substrings( TEXT, TEXT, INT ) RETURNS TEXT AS $$
6 my $string = shift; # Source string
7 my $pad = shift; # string to fill. Typically '0'. This should be a single character.
8 my $len = shift; # length of resultant padded field
10 $string =~ s/([0-9]+)/$pad x ($len - length($1)) . $1/eg;
16 -- Correct any potentially incorrectly padded sortkeys
18 UPDATE biblio.monograph_part SET label = label;
20 UPDATE asset.call_number_prefix SET label = label;
22 -- asset.call_number.label_sortkey doesn't make use of this function
24 UPDATE asset.call_number_suffix SET label = label;