1 -- Evergreen DB patch XXXX.function.axis_authority_tags_refs_aggregate.sql
5 -- check whether patch can be applied
6 SELECT evergreen.upgrade_deps_block_check('0784', :eg_version);
8 CREATE OR REPLACE FUNCTION authority.axis_authority_tags_refs(a TEXT) RETURNS INT[] AS $$
9 SELECT ARRAY_AGG(y) from (
10 SELECT unnest(ARRAY_CAT(
12 (SELECT ARRAY_ACCUM(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.field)
14 FROM authority.browse_axis_authority_field_map a
18 CREATE OR REPLACE FUNCTION authority.btag_authority_tags_refs(btag TEXT) RETURNS INT[] AS $$
19 SELECT ARRAY_AGG(y) from (
20 SELECT unnest(ARRAY_CAT(
21 ARRAY[a.authority_field],
22 (SELECT ARRAY_ACCUM(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.authority_field)
24 FROM authority.control_set_bib_field a
28 CREATE OR REPLACE FUNCTION authority.atag_authority_tags_refs(atag TEXT) RETURNS INT[] AS $$
29 SELECT ARRAY_AGG(y) from (
30 SELECT unnest(ARRAY_CAT(
32 (SELECT ARRAY_ACCUM(x.id) FROM authority.control_set_authority_field x WHERE x.main_entry = a.id)
34 FROM authority.control_set_authority_field a