nocfbot-0040-Reword-RPR-navigation-descriptions-pg_proc.dat.txt

From 8339a5783d3c9738f043e8aea9d02ecfffe42af0 Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
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)