3 SELECT evergreen.upgrade_deps_block_check('0978', :eg_version);
5 -- note: it is not necessary to explicitly drop the previous VARIADIC
6 -- version of this stored procedure; create or replace function...
8 CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting_batch( org_id INT, setting_names TEXT[] ) RETURNS SETOF actor.org_unit_setting AS $$
14 FOREACH setting_name IN ARRAY setting_names
18 SELECT INTO setting * FROM actor.org_unit_setting WHERE org_unit = cur_org AND name = setting_name;
23 SELECT INTO cur_org parent_ou FROM actor.org_unit WHERE id = cur_org;
24 EXIT WHEN cur_org IS NULL;
29 $$ LANGUAGE plpgsql STABLE;
31 COMMENT ON FUNCTION actor.org_unit_ancestor_setting_batch( INT, TEXT[] ) IS $$
32 For each setting name passed, search "up" the org_unit tree until
33 we find the first occurrence of an org_unit_setting with the given name.