↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

first_value

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

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 value evaluated at the row that is the first row of the window frame.

Signatures and overloads

first_value ( value anyelement ) → anyelement → anyelement
Returns value evaluated at the row that is the first row of the window frame.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:11acdeb6accfb7498df3df1d8ce00dcbb12ff75d73415cfb75eb088fb5df47dd

Text language: en · wiki-repair-20261023:11acdeb6accfb7498df3df1d8ce00dcbb12ff75d73415cfb75eb088fb5df47dd