News for hackers. Stuff that matters.

A comment on Recursive SQL Queries with PostgreSQL.

Re:Recursive SQL Queries with PostgreSQL by PaulMest on Monday March 16, 2020 @04:08AM (#22590911)
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

[ Parent | on HN ]
Re:Recursive SQL Queries with PostgreSQL by maweki on Monday March 16, 2020 @04:13AM (#22590924)
Use it. I think you get stronger guarantees on correctness and performance.

Not every of those path queries are easily implemented using recursive CTEs.

[ Parent | on HN ]