2 ms·
Postgres recursive queries make them pretty simple to deal with. This[1] is the query I used to pull a list of all a stories children recursively. 1. https://g
by orf 11y ago
Postgres recursive queries make them pretty simple to deal with. This[1] is the query I used to pull a list of all a stories children recursively.
1. https://gist.github.com/orf/5565a572c6ddda039d6f https://gist.github.com/orf/5565a572c6ddda039d6f
- Kinnard 11y agoHmmm, I'm trying to decide between this recursive query or something using ltrees. Can't make up my mind . . . [1] https://truongtx.me/2014/02/28/tree-structure-query-with-postgresql/ https://truongtx.me/2014/02/28/tree-structure-query-with-pos... [2] http://stackoverflow.com/questions/603894/is-postgresqls-ltree-module-a-good-fit-for-threaded-comments http://stackoverflow.com/questions/603894/is-postgresqls-ltr...