1 CREATE TEMPORARY VIEW ancestor_view AS
3 ancestor (uuid, ancestor_uuid) AS (
4 SELECT groups.uuid::varchar(32) AS uuid,
5 groups.owner_uuid::varchar(32) AS ancestor_uuid
8 SELECT ancestor.uuid::varchar(32) AS uuid,
9 groups.owner_uuid::varchar(32) AS ancestor_uuid
12 ON groups.uuid = ancestor.ancestor_uuid
14 SELECT * FROM ancestor;