3 SELECT evergreen.upgrade_deps_block_check('0541', :eg_version); -- dbwells
5 ALTER TABLE asset.call_number ALTER COLUMN label_class DROP DEFAULT;
7 CREATE OR REPLACE FUNCTION asset.label_normalizer() RETURNS TRIGGER AS $func$
11 sortkey := NEW.label_sortkey;
13 IF NEW.label_class IS NULL THEN
14 NEW.label_class := COALESCE( (SELECT substring(value from E'\\d+')::integer from actor.org_unit_setting WHERE name = 'cat.default_classification_scheme' AND org_unit = NEW.owning_lib), 1);
17 EXECUTE 'SELECT ' || acnc.normalizer || '(' ||
18 quote_literal( NEW.label ) || ')'
19 FROM asset.call_number_class acnc
20 WHERE acnc.id = NEW.label_class
22 NEW.label_sortkey = sortkey;
25 $func$ LANGUAGE PLPGSQL;