3 SELECT evergreen.upgrade_deps_block_check('1228', :eg_version);
5 CREATE OR REPLACE FUNCTION actor.org_unit_full_path ( INT ) RETURNS SETOF actor.org_unit AS $$
7 FROM actor.org_unit AS aou
9 (SELECT au.id, t.depth FROM actor.org_unit_ancestors($1) AS au JOIN actor.org_unit_type t ON (au.ou_type = t.id))
11 (SELECT au.id, t.depth FROM actor.org_unit_descendants($1) AS au JOIN actor.org_unit_type t ON (au.ou_type = t.id))
12 ) AS ad ON (aou.id=ad.id)
14 $$ LANGUAGE SQL STABLE;