Fun with SQL: Recursive CTEs in PostgreSQL

Common Table Expressions (CTEs) are a powerful construct within SQL. In day-to-day conversation, you may hear CTEs referred to as WITH clauses. You can think of CTEs as similar to a view that is materialized only while that query is running and does not exist outside of that query. CTEs can be very useful building blocks for allowing your large SQL queries to be more readable, but they can also be used recursively, allowing you to create some very complex queries without having to drop down...

What feeling does this article give you?

#hashtags to follow:

Common Table Expressions [+]    CTEs [+]    SQL [+]   

More #news: