select * from tree where level > 4;
WITH RECURSIVE child_to_parents AS (
SELECT addrobj.* FROM addrobj
WHERE aoid = '51f21baa-c804-4737-9d5f-9da7a3bb1598'
UNION ALL
SELECT addrobj.* FROM addrobj, child_to_parents
WHERE addrobj.aoguid = child_to_parents.parentguid
AND addrobj.currstatus = 0
)
SELECT * FROM child_to_parents ORDER BY aolevel;
Пример класса
Ниже пример этих данных, приходящих извне