You are viewing a single comment's thread. Return to all comments →
WHEN I TRY SAME THING IN POSTGRESSQL I GOT RESULT NOT SURE WHY OTHER DBS ARE NOT SUPPORTING FYI..
select N AS NODE, case when P IS NULL THEN 'ROOT' when N IN (select distinct P from bst ) THEN 'LEAF' else 'Inner' end as nodeType from bst;
1 "Inner" 3 "Inner" 6 "Inner" 9 "Inner" 2 "LEAF" 8 "LEAF" 5 "ROOT"
Seems like cookies are disabled on this browser, please enable them to open this website
Binary Tree Nodes
You are viewing a single comment's thread. Return to all comments →
WHEN I TRY SAME THING IN POSTGRESSQL I GOT RESULT NOT SURE WHY OTHER DBS ARE NOT SUPPORTING FYI..
select N AS NODE, case when P IS NULL THEN 'ROOT' when N IN (select distinct P from bst ) THEN 'LEAF' else 'Inner' end as nodeType from bst;
1 "Inner" 3 "Inner" 6 "Inner" 9 "Inner" 2 "LEAF" 8 "LEAF" 5 "ROOT"