Authorities: 4XX fields have wrong names
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.data.authority_4xx_fields.sql
1 BEGIN;
2
3 -- check whether patch can be applied
4 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5
6 UPDATE authority.control_set_authority_field
7     SET name = REGEXP_REPLACE(name, '^See Also', 'See From')
8     WHERE tag LIKE '4__' AND control_set = 1;
9
10 COMMIT;