3 SELECT evergreen.upgrade_deps_block_check('0946', :eg_version);
5 CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting_batch( org_id INT, VARIADIC setting_names TEXT[] ) RETURNS SETOF actor.org_unit_setting AS $$
11 FOREACH setting_name IN ARRAY setting_names
15 SELECT INTO setting * FROM actor.org_unit_setting WHERE org_unit = cur_org AND name = setting_name;
20 SELECT INTO cur_org parent_ou FROM actor.org_unit WHERE id = cur_org;
21 EXIT WHEN cur_org IS NULL;
26 $$ LANGUAGE plpgsql STABLE;
28 COMMENT ON FUNCTION actor.org_unit_ancestor_setting_batch( INT, VARIADIC TEXT[] ) IS $$
29 For each setting name passed, search "up" the org_unit tree until
30 we find the first occurrence of an org_unit_setting with the given name.