v1-0001-doc-Fix-typo-in-rule-system-view-example.patch

application/octet-stream

Filename: v1-0001-doc-Fix-typo-in-rule-system-view-example.patch
Type: application/octet-stream
Part: 0
Message: Re: Check query

Patch

Format: format-patch
Series: patch v1-0001
Subject: doc: Fix typo in rule-system view example
File+
doc/src/sgml/rules.sgml 1 1
From 3da9967172d0664cf6ab49f4f3aef8161bd03347 Mon Sep 17 00:00:00 2001
From: Fujii Masao <fujii@postgresql.org>
Date: Tue, 7 Jul 2026 09:44:22 +0900
Subject: [PATCH v1] doc: Fix typo in rule-system view example

Commit dcb00495236 accidentally changed the final expanded query's
condition to > 2 while rewriting the example into SQL operator notation.

The original query and the preceding rewritten forms all use >= 2,
and view expansion should preserve that qualification. This commit
changes the final condition from > 2 to >= 2.

Backpatch to all supported versions.

Reported-by: Yaroslav Saburov <y.saburov@gmail.com>
Discussion: https://postgr.es/m/178248467618.108999.9966122434342474006@wrigleys.postgresql.org
Backpatch-through: 14
---
 doc/src/sgml/rules.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/rules.sgml b/doc/src/sgml/rules.sgml
index 7f23962f524..9f9fa978f2d 100644
--- a/doc/src/sgml/rules.sgml
+++ b/doc/src/sgml/rules.sgml
@@ -631,7 +631,7 @@ SELECT shoe_ready.shoename, shoe_ready.sh_avail,
          WHERE rsl.sl_color = rsh.slcolor
            AND rsl.sl_len_cm &gt;= rsh.slminlen_cm
            AND rsl.sl_len_cm &lt;= rsh.slmaxlen_cm) shoe_ready
- WHERE shoe_ready.total_avail &gt; 2;
+ WHERE shoe_ready.total_avail &gt;= 2;
 </programlisting>
    </para>
 
-- 
2.55.0