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