upgrade-20210819.sql

SET ROLE 'mo_osmo';

-- Musí udělat správce (ale uvnitř naší DB):
-- CREATE EXTENSION unaccent;

CREATE OR REPLACE FUNCTION f_unaccent(text)
  RETURNS text AS
$func$
SELECT unaccent('unaccent', $1)
$func$  LANGUAGE sql IMMUTABLE SET search_path = public, pg_temp;

CREATE INDEX places_noacc_index ON places ((lower(f_unaccent(name))) text_pattern_ops);