Bruce Momjian: Programming the SQL Way with Common Table Expressions

SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages. This talk will help developers use implement CTE queries in their applications and allow operations that normally could only be done in application code to be done via SQL queries.

Length: 57:20

Views 509 Likes: 3

Recorded on 2012-09-17 at Postgres Open

Look for other videos at Postgres Open.

Tweet this video