↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / Window Functions

first_value

Read the PG 18 manual

Returns value evaluated at the row that is the first row of the window frame.

Reading PG 18current·documented in 19 of 27 versions, 8.4 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

first_value ( value anyelement ) → anyelement
Returns value evaluated at the row that is the first row of the window frame.
Version history 3
  1. 18 → 19 changed
  2. 12 → 13 changed
  3. 8.3 → 8.4 added

Definition snapshot: b7bd9cda · English manual source