Making use of onboard windowing functions

Having introduced you to the basic concepts, it is time to take a look at which windowing functions PostgreSQL will support out-of-the-box. You have already seen that windowing works with all standard aggregate functions. On top of those functions, PostgreSQL offers some additional functions that are exclusively for windowing and analytics.

In this section, some highly important functions will be explained and discussed.