3 SELECT evergreen.upgrade_deps_block_check('1020', :eg_version);
5 CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting_batch_by_org(
6 setting_name TEXT, org_ids INTEGER[])
7 RETURNS SETOF actor.org_unit_setting AS
13 /* Returns one actor.org_unit_setting row per org unit ID provided.
14 When no setting exists for a given org unit, the setting row
15 will contain all empty values. */
16 FOREACH org_id IN ARRAY org_ids LOOP
17 SELECT INTO setting * FROM
18 actor.org_unit_ancestor_setting(setting_name, org_id);
23 $FUNK$ LANGUAGE plpgsql STABLE;