Conference 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.

Speaker

Gianni Ciolli