1 -- Evergreen DB patch 0607.schema.oua_force_order.sql
7 -- check whether patch can be applied
8 SELECT evergreen.upgrade_deps_block_check('0607', :eg_version);
10 CREATE OR REPLACE FUNCTION actor.org_unit_ancestors( INT ) RETURNS SETOF actor.org_unit AS $$
11 WITH RECURSIVE org_unit_ancestors_distance(id, distance) AS (
14 SELECT ou.parent_ou, ouad.distance+1
15 FROM actor.org_unit ou JOIN org_unit_ancestors_distance ouad ON (ou.id = ouad.id)
16 WHERE ou.parent_ou IS NOT NULL
18 SELECT ou.* FROM actor.org_unit ou JOIN org_unit_ancestors_distance ouad USING (id) ORDER BY ouad.distance DESC;
19 $$ LANGUAGE SQL ROWS 1;