CTE's are awesome indeed :)<p>As another interesting use case, here's the solution of the "eight queens problem" in Postgres:<p><a href="https://gist.github.com/adewes/5e5397b693eb50e67f07" rel="nofollow">https://gist.github.com/adewes/5e5397b693eb50e67f07</a><p>An here's the accompanying article:<p><a href="http://andreas-dewes.de/articles/solving-the-eight-queens-problem-in-sql.html" rel="nofollow">http://andreas-dewes.de/articles/solving-the-eight-queens-pr...</a>
(Better?) known also as the Syracuse problem: I had never heard about the "Collatz conjecture"; in French speaking countries, it's exclusively called the Syracuse problem.<p>I wonder how names for this conjecture have diverged like that...
This requires a GitHub account, and I have deleted my GitHub account after a GitHub VP said "The problem for diversity is the white women" (in a leaked presentation at the end of last year). <a href="https://www.reddit.com/r/pics/comments/44ttzj/racist_diversity_training_at_github/" rel="nofollow">https://www.reddit.com/r/pics/comments/44ttzj/racist_diversi...</a>