1 -- Evergreen DB patch XXXX.fix_aous_lookup.sql
3 -- Correct actor.org_unit_ancestor_setting so that it returns
4 -- at most one setting value, rather than the entire set
5 -- of values defined for the OU and its ancestors.
10 -- check whether patch can be applied
11 SELECT evergreen.upgrade_deps_block_check('0601', :eg_version);
13 -- FIXME: add/check SQL statements to perform the upgrade
14 CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting( setting_name TEXT, org_id INT ) RETURNS SETOF actor.org_unit_setting AS $$
21 SELECT INTO setting * FROM actor.org_unit_setting WHERE org_unit = cur_org AND name = setting_name;
26 SELECT INTO cur_org parent_ou FROM actor.org_unit WHERE id = cur_org;
27 EXIT WHEN cur_org IS NULL;
31 $$ LANGUAGE plpgsql STABLE ROWS 1;