↑↓ select ↵ open ⌫ change scope Open full search

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

Functions / Window Functions

row_number

Read the PG 18 manual

Returns the number of the current row within its partition, counting from 1.

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

row_number () → bigint
Returns the number of the current row within its partition, counting from 1.
Version history 2
  1. 12 → 13 changed
  2. 8.3 → 8.4 added

Definition snapshot: b7bd9cda · English manual source