3 INSERT INTO config.upgrade_log (version) VALUES ('0033'); -- miker
6 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
8 'Apply NACO normalization rules to the extracted text. See http://www.loc.gov/catdir/pcc/naco/normrule-2.html for details.',
13 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
14 'Normalize date range',
15 'Split date ranges in the form of "XXXX-YYYY" into "XXXX YYYY" for proper index.',
20 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
21 'NACO Normalize -- retain first comma',
22 'Apply NACO normalization rules to the extracted text, retaining the first comma. See http://www.loc.gov/catdir/pcc/naco/normrule-2.html for details.',
23 'naco_normalize_keep_comma',
27 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
29 'Convert text to NFD form and remove non-spacing combining marks.',
34 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
36 'Convert text upper case.',
41 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
43 'Convert text lower case.',
48 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
49 'Extract Dewey-like number',
50 'Extract a string of numeric characters ther resembles a DDC number.',
55 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
57 'Discard the specified number of characters from the left side of the string.',
62 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
64 'Include only the specified number of characters from the left side of the string.',
69 INSERT INTO config.index_normalizer (name, description, func, param_count) VALUES (
71 'Include only the first space-separated word of a string.',
77 INSERT INTO config.metabib_field_index_norm_map (field,norm)
80 FROM config.metabib_field m,
81 config.index_normalizer i
82 WHERE i.func IN ('naco_normalize','split_date_range');