Recursive Postgres Queries

Re:Recursive Postgres Queries by chrisfarms on Monday June 24, 2013 @10:55AM (#5933286)

I've implemented similar designs in the past, but found ltree[1] to be much more useful/expressive when it comes to needing to fetch, order and manage lists of hierarchical data.

[1] http://www.postgresql.org/docs/9.3/static/ltree.html

[ Parent | on HN ]

Re:Recursive Postgres Queries by joevandyk on Monday June 24, 2013 @02:20PM (#5934686)

How do you handle ordering of list elements? (say I have a "position" column that subcategories need to be sorted by)

[ Parent | on HN ]

Re:Recursive Postgres Queries by p0wl on Monday June 24, 2013 @02:19PM (#5934684)

also: Nested Sets http://en.wikipedia.org/wiki/Nested_set_model

Saved me a couple of times.

[ Parent | on HN ]