From 8339a5783d3c9738f043e8aea9d02ecfffe42af0 Mon Sep 17 00:00:00 2001 From: Henson Choi Date: Sat, 2 May 2026 01:19:37 +0900 Subject: [PATCH 40/40] Reword RPR navigation function descriptions in pg_proc.dat The descr fields for prev/next/first/last in pg_proc.dat were written tersely (e.g. 'previous value', 'first value in match'), inconsistent with the surrounding window-function entries that all follow a 'fetch the ... row value' style (lag, lead, first_value, last_value, nth_value). Reword the eight RPR navigation entries to match that pattern, while distinguishing partition-scoped (prev/next) from match-scoped (first/last) navigation in the wording. prev / prev_offset: fetch the (Nth) preceding row value next / next_offset: fetch the (Nth) following row value first / first_offset: fetch the (Nth) first row value within match last / last_offset: fetch the (Nth-from-)last row value within match Catalog descr only; no functional or test impact. Visible to users through psql's \df+ output. --- src/include/catalog/pg_proc.dat | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat index 6d70ed23aeb..55c41e66100 100644 --- a/src/include/catalog/pg_proc.dat +++ b/src/include/catalog/pg_proc.dat @@ -10972,28 +10972,28 @@ { oid => '3114', descr => 'fetch the Nth row value', proname => 'nth_value', prokind => 'w', prorettype => 'anyelement', proargtypes => 'anyelement int4', prosrc => 'window_nth_value' }, -{ oid => '8126', descr => 'previous value', +{ oid => '8126', descr => 'fetch the preceding row value', proname => 'prev', provolatile => 's', prorettype => 'anyelement', proargtypes => 'anyelement', prosrc => 'window_prev' }, -{ oid => '8128', descr => 'previous value at offset', +{ oid => '8128', descr => 'fetch the Nth preceding row value', proname => 'prev', provolatile => 's', proisstrict => 'f', prorettype => 'anyelement', proargtypes => 'anyelement int8', prosrc => 'window_prev_offset' }, -{ oid => '8127', descr => 'next value', +{ oid => '8127', descr => 'fetch the following row value', proname => 'next', provolatile => 's', prorettype => 'anyelement', proargtypes => 'anyelement', prosrc => 'window_next' }, -{ oid => '8129', descr => 'next value at offset', +{ oid => '8129', descr => 'fetch the Nth following row value', proname => 'next', provolatile => 's', proisstrict => 'f', prorettype => 'anyelement', proargtypes => 'anyelement int8', prosrc => 'window_next_offset' }, -{ oid => '8130', descr => 'first value in match', +{ oid => '8130', descr => 'fetch the first row value within match', proname => 'first', provolatile => 's', prorettype => 'anyelement', proargtypes => 'anyelement', prosrc => 'window_first' }, -{ oid => '8132', descr => 'first value in match at offset', +{ oid => '8132', descr => 'fetch the Nth row value within match', proname => 'first', provolatile => 's', proisstrict => 'f', prorettype => 'anyelement', proargtypes => 'anyelement int8', prosrc => 'window_first_offset' }, -{ oid => '8131', descr => 'last value in match', +{ oid => '8131', descr => 'fetch the last row value within match', proname => 'last', provolatile => 's', prorettype => 'anyelement', proargtypes => 'anyelement', prosrc => 'window_last' }, -{ oid => '8133', descr => 'last value in match at offset', +{ oid => '8133', descr => 'fetch the Nth-from-last row value within match', proname => 'last', provolatile => 's', proisstrict => 'f', prorettype => 'anyelement', proargtypes => 'anyelement int8', prosrc => 'window_last_offset' }, -- 2.50.1 (Apple Git-155)