row_number () → bigint → bigintReturns the number of the current row within its partition, counting from 1.
row_number
Returns the number of the current row within its partition, counting from 1.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- group
- window
- group label
- Window Functions
- lang
- en
- layout
- table-new
- pages
- functions-window.html
- prose only
- false
Definition PG 18
Returns the number of the current row within its partition, counting from 1.
Signatures and overloads
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:1749ab9fc4d5ba9f6eeb1ed3d6aaea50814552bafdf011862f3c0518f02f6c29
Text language: en · wiki-repair-20261023:1749ab9fc4d5ba9f6eeb1ed3d6aaea50814552bafdf011862f3c0518f02f6c29