3 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
5 CREATE OR REPLACE FUNCTION permission.grp_descendants( INT ) RETURNS SETOF permission.grp_tree AS $$
6 WITH RECURSIVE descendant_depth AS (
9 FROM permission.grp_tree gr
14 FROM permission.grp_tree gr
15 JOIN descendant_depth dd ON (dd.id = gr.parent)
16 ) SELECT gr.* FROM permission.grp_tree gr JOIN descendant_depth USING (id);
17 $$ LANGUAGE SQL STABLE ROWS 1;