Open-ILS/src/sql/Pg/upgrade/1008.schema.patron_punct.sql

   1 BEGIN;
   2
   3 SELECT evergreen.upgrade_deps_block_check('1008', :eg_version);
   4
   5 CREATE OR REPLACE FUNCTION evergreen.unaccent_and_squash ( IN arg text) RETURNS text
   6     IMMUTABLE STRICT AS $$
   7         BEGIN
   8         RETURN evergreen.lowercase(unaccent(regexp_replace(arg, '[\s[:punct:]]','','g')));
   9         END;
  10 $$ LANGUAGE PLPGSQL;
  11
  12 -- Upon upgrade, we need to
  13 -- reindex because the definition of the unaccent_and_squash function
  14 -- has changed.
  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;
  18
  19 COMMIT;
  20
  21