May 2018
Intermediate to advanced
576 pages
30h 25m
English
Another possibility for achieving similar results to temporary tables and/or materialized views is by using a set-returning function for some parts of the query.
It is easy to have a materialized view freshness check inside a function. However, a detailed analysis and an overview of these techniques go beyond the goals of this book, as they require a deep understanding of the PL/pgSQL procedural language.