egdb3_12_9
.permission
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
grp_ancestors(integer)
Parameters
Name
Type
Mode
integer
IN
Definition
WITH RECURSIVE grp_ancestors_distance(id, distance) AS ( SELECT $1, 0 UNION SELECT ou.parent, ouad.distance+1 FROM permission.grp_tree ou JOIN grp_ancestors_distance ouad ON (ou.id = ouad.id) WHERE ou.parent IS NOT NULL ) SELECT ou.* FROM permission.grp_tree ou JOIN grp_ancestors_distance ouad USING (id) ORDER BY ouad.distance DESC;