Hierarchical data metrics that allows fast read operations on tree like structures.
Based on Left and Right fields that are set during tree traversal. When entered into node value is set to it's Left, when exiting node value is set to it's Right.
CREATE EXTENSION ltree; | |
CREATE TABLE test (path ltree); | |
-- Top | |
-- / | \ | |
-- Science Hobbies Collections | |
-- / | \ | |
-- Astronomy Amateurs_Astronomy Pictures |
Hierarchical data metrics that allows fast read operations on tree like structures.
Based on Left and Right fields that are set during tree traversal. When entered into node value is set to it's Left, when exiting node value is set to it's Right.