In Postgres you have the ability to write recursive queries that refer to
themselves. This is a very powerful construct, and among other use cases …
I started using Postgres a couple years ago and have really enjoyed the experience. Previously I had used Sql Server, MySQL, Firebird, and SQLite (I liked SQLite out of that group; smal,l quick, and embedded). Postgres just worked; everything I threw at it was handled and handled well.
Its great to add a new tool to my arsenal for Postgres; I’m looking forward to trying this out. I’m not sure where I would apply it to production systems yet; the variable in performance is something to keep in mind. Assuming you will be returning for the data anyway; these queries should return better results than having to perform multiple requests.
See on practiceovertheory.com