December 9th, 2012 by depesz | Tags: cte, cute, postgresql, primer, recursive, wcte, with, with recursive | 2 comments »
In PostgreSQL 8.4 we got CTE - Common Table Expressions. Since then we have this great tool available, but apparently for some people it's still black magic. CuTE, but still magic. I'll try to make it a bit less magical, ...