egdb3_11_7
.permission
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
grp_ancestors_distance(integer)
Parameters
Name
Type
Mode
integer
IN
id
integer
TABLE
distance
integer
TABLE
Definition
WITH RECURSIVE grp_ancestors_distance(id, distance) AS ( SELECT $1, 0 UNION SELECT pgt.parent, gad.distance+1 FROM permission.grp_tree pgt JOIN grp_ancestors_distance gad ON (pgt.id = gad.id) WHERE pgt.parent IS NOT NULL ) SELECT * FROM grp_ancestors_distance;