Schedule - PGConf.EU 2019
Business Intelligence with Window Functions in PostgreSQL 11
Date: 2019-10-17
Time: 10:30–11:20
Room: Foscolo
Level: Intermediate
Window functions are a very useful tool. They are used for various use cases where a simple aggregation is not flexible enough: incremental totals, moving averages, etc.
PostgreSQL 11 supports the full SQL:2011 standard, with capabilities such as rows / range frames, GROUPS mode, exclusions.
In this talk we will review what users can do with window functions nowadays, and illustrate each specific feature with an example which is examined in detail.