3 SELECT evergreen.upgrade_deps_block_check('0986', :eg_version);
5 CREATE EXTENSION IF NOT EXISTS unaccent SCHEMA public;
7 CREATE OR REPLACE FUNCTION evergreen.unaccent_and_squash ( IN arg text) RETURNS text
10 RETURN evergreen.lowercase(unaccent(regexp_replace(arg, '\s','','g')));
14 -- The unaccented indices for patron name fields
15 CREATE INDEX actor_usr_first_given_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(first_given_name));
16 CREATE INDEX actor_usr_second_given_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(second_given_name));
17 CREATE INDEX actor_usr_family_name_unaccent_idx ON actor.usr (evergreen.unaccent_and_squash(family_name));
19 -- DB setting to control behavior; true by default
20 INSERT INTO config.org_unit_setting_type
21 ( name, grp, label, description, datatype )
23 ('circ.patron_search.diacritic_insensitive',
25 oils_i18n_gettext('circ.patron_search.diacritic_insensitive',
26 'Patron search diacritic insensitive',
28 oils_i18n_gettext('circ.patron_search.diacritic_insensitive',
29 'Match patron last, first, and middle names irrespective of usage of diacritical marks or spaces. (e.g., Ines will match Inés; de la Cruz will match Delacruz)',
30 'coust', 'description'),
33 INSERT INTO actor.org_unit_setting (
36 (SELECT id FROM actor.org_unit WHERE parent_ou IS NULL),
37 'circ.patron_search.diacritic_insensitive',