Programming the SQL Way with Common Table Expression
Join Postgres expert, Bruce Momjian, as he discusses common table expressions (CTEs) and the ability to allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages.
Highlights include:
- The comparison between imperative and declarative programming languages
- Examples of syntax & recursive CTEs
- Writeable CTEs and the importance of using CTEs
Highlights include:
- The comparison between imperative and declarative programming languages
- Examples of syntax & recursive CTEs
- Writeable CTEs and the importance of using CTEs
