ʻO nā ʻōnaehana hoʻokele waihona ʻikepili pili e pili ana iā SQL he hapa wale nō ia no nā nīnau hierarchical a recursive paha. ʻOi aku ka maikaʻi o nā ʻōnaehana ʻē aʻe e like me ArangoDB no kēia (ua nui ka kamaʻilio e pili ana i kēia ma GOTO 2016 ). Eia nō naʻe, hiki nō hoʻi ke hana i nā nīnau recursive ma SQL me ka hoʻohana ʻana i nā Common Table Expressions , e ʻae ana iā ʻoe, no ka laʻana, e nīnau i nā papa makua/keiki maʻamau no nā kūpuna a me nā mamo āpau.
Ma PostgreSQL like ke ʻano o kēia, no ka laʻana:
0672c4761d202a35a9059fa137ace7c3
Inā makemake ʻoe e kiʻi i nā keiki āpau o kekahi mea_id, hoʻohana ʻoe i nā Hōʻike Papa Hōʻuluʻulu Manaʻo:
0672c4761d202a35a9059fa137ace7c3
ʻAʻole pilikia ka nīnau ʻana i nā mākua:
0672c4761d202a35a9059fa137ace7c3