nocfbot-0036-Reword-RPR-navigation-function-synopses.txt

From 9ec53a2c53e1aa80c40e7997981021b0c1060297 Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
Date: Sat, 2 May 2026 00:51:47 +0900
Subject: [PATCH 36/40] Reword RPR navigation function synopses

The first-line synopses of prev/next/first/last in func-window.sgml
read "Returns the column value at the row ...".  This is too narrow:
the first argument is an arbitrary expression (e.g. first(col1 +
col2)), not just a column reference.

Reword each of the four entries to "Returns <value> evaluated at the
row that is <offset> rows ...", matching the wording already used by
lag, lead, first_value, and last_value in the same table.  This both
addresses the narrowness and aligns the navigation functions with
the established window-function documentation idiom.

Documentation-only change.
---
 doc/src/sgml/func/func-window.sgml | 19 +++++++++++--------
 1 file changed, 11 insertions(+), 8 deletions(-)

diff --git a/doc/src/sgml/func/func-window.sgml b/doc/src/sgml/func/func-window.sgml
index d109a2d22bc..d1da105ad0f 100644
--- a/doc/src/sgml/func/func-window.sgml
+++ b/doc/src/sgml/func/func-window.sgml
@@ -308,8 +308,9 @@
         <returnvalue>anyelement</returnvalue>
        </para>
        <para>
-        Returns the column value at the row <parameter>offset</parameter>
-        rows before the current row within the partition;
+        Returns <parameter>value</parameter> evaluated at the row that is
+        <parameter>offset</parameter> rows before the current row within
+        the partition;
         returns NULL if the target row is outside the partition.
         <parameter>offset</parameter> defaults to 1 if omitted.
         <parameter>offset</parameter> must be a non-negative integer;
@@ -328,8 +329,9 @@
         <returnvalue>anyelement</returnvalue>
        </para>
        <para>
-        Returns the column value at the row <parameter>offset</parameter>
-        rows after the current row within the partition;
+        Returns <parameter>value</parameter> evaluated at the row that is
+        <parameter>offset</parameter> rows after the current row within
+        the partition;
         returns NULL if the target row is outside the partition.
         <parameter>offset</parameter> defaults to 1 if omitted.
         <parameter>offset</parameter> must be a non-negative integer;
@@ -348,8 +350,8 @@
         <returnvalue>anyelement</returnvalue>
        </para>
        <para>
-        Returns the column value at the row <parameter>offset</parameter>
-        rows after the match start row;
+        Returns <parameter>value</parameter> evaluated at the row that is
+        <parameter>offset</parameter> rows after the match start row;
         returns NULL if the target row is beyond the current row.
         <parameter>offset</parameter> defaults to 0 if omitted, referring to the
         match start row itself.
@@ -368,8 +370,9 @@
         <returnvalue>anyelement</returnvalue>
        </para>
        <para>
-        Returns the column value at the row <parameter>offset</parameter>
-        rows before the current row within the match;
+        Returns <parameter>value</parameter> evaluated at the row that is
+        <parameter>offset</parameter> rows before the current row within
+        the match;
         returns NULL if the target row is before the match start row.
         <parameter>offset</parameter> defaults to 0 if omitted, referring to the
         current row itself.
-- 
2.50.1 (Apple Git-155)