Window Column Configuration Dialog Box

The Window Column Configuration dialog box enables you to configure window columns for an aggregate calculation.

Enter the name of the window column to create in the Result Column field, the window function expression in the Window Function field, and the window OVER specification for the window column in the Window Specification field.

You can choose the data type of the window function column in the Data Type drop-down list.

Data type options:

  • BIGINT
  • BOOLEAN
  • BIT
  • BIT VARYING
  • CHAR
  • DATE
  • DOUBLE PRECISION
  • NUMERIC
  • INTEGER
  • VARCHAR

Click New field to add another window column. Click Delete to remove a window column.

For more information about PostgreSQL window function calls, see PostgreSQL Window Functions .

Important: The windowing functionality is not supported for generic JDBC data sources.