3 INSERT INTO config.upgrade_log (version) VALUES ('0315'); --miker
5 CREATE OR REPLACE FUNCTION public.remove_paren_substring( TEXT ) RETURNS TEXT AS $$
6 SELECT regexp_replace($1, $$\([^)]+\)$$, '', 'g');
7 $$ LANGUAGE SQL STRICT IMMUTABLE;
9 INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, facet_field, search_field ) VALUES
10 (26, 'identifier', 'arcn', oils_i18n_gettext(26, 'Authority record control number', 'cmf', 'label'), 'marcxml', $$//marc:subfield[@code='0']$$, TRUE, FALSE );
12 SELECT SETVAL('config.metabib_field_id_seq'::TEXT, (SELECT MAX(id) FROM config.metabib_field), TRUE);
14 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
15 'Remove Parenthesized Substring',
16 'Remove any parenthesized substrings from the extracted text, such as the agency code preceding authority record control numbers in subfield 0.',
17 'remove_paren_substring',
21 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
22 'Trim Surrounding Space',
23 'Trim leading and trailing spaces from extracted text.',
28 INSERT INTO config.metabib_field_index_norm_map (field,norm,pos)
32 FROM config.metabib_field m,
33 config.index_normalizer i
34 WHERE i.func IN ('remove_paren_substring')
37 INSERT INTO config.metabib_field_index_norm_map (field,norm,pos)
41 FROM config.metabib_field m,
42 config.index_normalizer i
43 WHERE i.func IN ('btrim')