From 9ec53a2c53e1aa80c40e7997981021b0c1060297 Mon Sep 17 00:00:00 2001 From: Henson Choi 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 evaluated at the row that is 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 @@ anyelement - Returns the column value at the row offset - rows before the current row within the partition; + Returns value evaluated at the row that is + offset rows before the current row within + the partition; returns NULL if the target row is outside the partition. offset defaults to 1 if omitted. offset must be a non-negative integer; @@ -328,8 +329,9 @@ anyelement - Returns the column value at the row offset - rows after the current row within the partition; + Returns value evaluated at the row that is + offset rows after the current row within + the partition; returns NULL if the target row is outside the partition. offset defaults to 1 if omitted. offset must be a non-negative integer; @@ -348,8 +350,8 @@ anyelement - Returns the column value at the row offset - rows after the match start row; + Returns value evaluated at the row that is + offset rows after the match start row; returns NULL if the target row is beyond the current row. offset defaults to 0 if omitted, referring to the match start row itself. @@ -368,8 +370,9 @@ anyelement - Returns the column value at the row offset - rows before the current row within the match; + Returns value evaluated at the row that is + offset rows before the current row within + the match; returns NULL if the target row is before the match start row. offset defaults to 0 if omitted, referring to the current row itself. -- 2.50.1 (Apple Git-155)