This is for making a quick question and leaving a note: ?? What is a recursive aggregate query? What is it useful for? Been using SQL for a while, and is the first time I face the term. I even used Oracle for a year and a half, and never saw a CONNECT BY (seems to be a proprietary equivalent) in all the queries I ever saw (I did code maintenance from time to time).
I keep reading at this thread, and I see it becoming longer and longer, so I'm starting to believe "recursive aggregate queries" must be important somehow. As I'm a dummy, I read the Wikipedia entry for it, and I'm still at the same place... As I never saw the need for this kind of solution in my life, I believe I must see a rather interesting (and useful) example to actually dig the idea. Any place I can find it? By the way, as a note, the Wikipedia entry does mention CTE support from SQLite 3.8.3 onwards, and as I'm a bit confused by this thread right now, I'm not sure if CTEs and recursive queries go hand in hand, and I'm not sure if it's CTE as a whole or just recursive queries which are faulty in SQLite... To cut straight to the point, maybe Wikipedia shouldn't mention SQLite (if it's really buggy), and I believe someone with the understanding of the SQLite reality perhaps should go and edit the article: https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL I can do it myself, but I need confirmation from someone else.
