From 66cf7831331c90cef6702300241d1880276fcb2a Mon Sep 17 00:00:00 2001
From: Henson Choi <assam258@gmail.com>
Date: Mon, 31 Aug 2026 15:13:02 +0900
Subject: [PATCH] Correct two errors in the row pattern recognition
 documentation

row_pattern_common_syntax was listed inside the frame_clause synopsis, on
both of its forms.  The grammar puts opt_row_pattern_common_syntax beside
opt_frame_clause in window_specification rather than within it, so it
belongs in the window_definition synopsis, which did not mention it at all.

The note on the 240 pattern variable limit added that exceeding it raises
an error.  The nesting depth limit named in the next sentence raises one
too and does not say so, and a reader who notices the difference is invited
to conclude something untrue.
---
 doc/src/sgml/ref/select.sgml | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index e595bf5d1ac..15def1cfdcb 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -972,6 +972,7 @@ WINDOW <replaceable class="parameter">window_name</replaceable> AS ( <replaceabl
 [ PARTITION BY <replaceable class="parameter">expression</replaceable> [, ...] ]
 [ ORDER BY <replaceable class="parameter">expression</replaceable> [ ASC | DESC | USING <replaceable class="parameter">operator</replaceable> ] [ NULLS { FIRST | LAST } ] [, ...] ]
 [ <replaceable class="parameter">frame_clause</replaceable> ]
+[ <replaceable class="parameter">row_pattern_common_syntax</replaceable> ]
 </synopsis>
    </para>
 
@@ -1014,8 +1015,8 @@ WINDOW <replaceable class="parameter">window_name</replaceable> AS ( <replaceabl
     The <replaceable class="parameter">frame_clause</replaceable> can be one of
 
 <synopsis>
-{ RANGE | ROWS | GROUPS } <replaceable>frame_start</replaceable> [ <replaceable>frame_exclusion</replaceable> ] [ <replaceable>row_pattern_common_syntax</replaceable> ]
-{ RANGE | ROWS | GROUPS } BETWEEN <replaceable>frame_start</replaceable> AND <replaceable>frame_end</replaceable> [ <replaceable>frame_exclusion</replaceable> ] [ <replaceable>row_pattern_common_syntax</replaceable> ]
+{ RANGE | ROWS | GROUPS } <replaceable>frame_start</replaceable> [ <replaceable>frame_exclusion</replaceable> ]
+{ RANGE | ROWS | GROUPS } BETWEEN <replaceable>frame_start</replaceable> AND <replaceable>frame_end</replaceable> [ <replaceable>frame_exclusion</replaceable> ]
 </synopsis>
 
     where <replaceable>frame_start</replaceable>
@@ -1210,7 +1211,6 @@ DEFINE <replaceable class="parameter">definition_variable_name</replaceable> AS
    <para>
     Note that the maximum number of unique pattern variables
     used in the <literal>PATTERN</literal> clause is 240.
-    If this limit is exceeded, an error will be raised.
     Additionally, the maximum nesting depth of pattern groups
     (parentheses) is 254 levels.  An alternation costs a level of its own,
     so a pattern that nests alternations reaches the limit at about half