↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

last_value

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

Signatures and overloads

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

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:067d08d7ebe9123f2205e8d879ec7d9e830f9971b04a8499bef524dd46e06174

Text language: en · wiki-repair-20261023:067d08d7ebe9123f2205e8d879ec7d9e830f9971b04a8499bef524dd46e06174