Expand description

Window frame module

The frame-spec determines which output rows are read by an aggregate window function. The frame-spec consists of four parts:

  • A frame type - either ROWS, RANGE or GROUPS,
  • A starting frame boundary,
  • An ending frame boundary,
  • An EXCLUDE clause.

Structs

The frame-spec determines which output rows are read by an aggregate window function.

Enums

There are five ways to describe starting and ending frame boundaries:

There are three frame types: ROWS, GROUPS, and RANGE. The frame type determines how the starting and ending boundaries of the frame are measured.