3 SELECT evergreen.upgrade_deps_block_check('1008', :eg_version);
5 CREATE OR REPLACE FUNCTION evergreen.unaccent_and_squash ( IN arg text) RETURNS text
8 RETURN evergreen.lowercase(unaccent(regexp_replace(arg, '[\s[:punct:]]','','g')));
12 -- Upon upgrade, we need to
13 -- reindex because the definition of the unaccent_and_squash function
15 REINDEX INDEX actor.actor_usr_first_given_name_unaccent_idx;
16 REINDEX INDEX actor.actor_usr_second_given_name_unaccent_idx;
17 REINDEX INDEX actor.actor_usr_family_name_unaccent_idx;