2 ms·
My team just started working on a project that will work with hierarchical data. Have you looked into ltree[0] at all? Any thoughts on when that would or would
by PaulMest 7y ago
My team just started working on a project that will work with hierarchical data. Have you looked into ltree[0] at all? Any thoughts on when that would or would not be beneficial?
[0] https://www.postgresql.org/docs/current/ltree.html https://www.postgresql.org/docs/current/ltree.html
- maweki 7y agoUse it. I think you get stronger guarantees on correctness and performance. Not every of those path queries are easily implemented using recursive CTEs.