egdb3_11_7
.permission
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
grp_descendants(integer)
Parameters
Name
Type
Mode
integer
IN
Definition
WITH RECURSIVE descendant_depth AS ( SELECT gr.id, gr.parent FROM permission.grp_tree gr WHERE gr.id = $1 UNION ALL SELECT gr.id, gr.parent FROM permission.grp_tree gr JOIN descendant_depth dd ON (dd.id = gr.parent) ) SELECT gr.* FROM permission.grp_tree gr JOIN descendant_depth USING (id);