CTE's are awesome indeed :) As another interesting use case, here's the solution of the "eight queens problem" in Postgres: https://gist.github.com/adewes/5e5

CTE's are awesome indeed :) As another interesting use case, here's the solution of the "eight queens problem" in Postgres: https://gist.github.com/adewes/5e5397b693eb50e67f07 https://gist.github.com/adewes/5e5397b693eb50e67f07 An here's the accompanying article: http://andreas-dewes.de/articles/solving-the-eight-queens-problem-in-sql.html http://andreas-dewes.de/articles/solving-the-eight-queens-pr...