Functions / Window Functions

nth_value

Returns value evaluated at the row that is the n'th row of the window frame (counting from 1); returns NULL if there is no such row.

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

Signatures & examples

nth_value ( value anyelement, n integer ) → anyelement

Returns value evaluated at the row that is the n'th row of the window frame (counting from 1); returns NULL if there is no such row.

Version history 3

Definition snapshot: b7bd9cda · English manual source