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 >= rsh.slminlen_cm
AND rsl.sl_len_cm <= rsh.slmaxlen_cm) shoe_ready
- WHERE shoe_ready.total_avail > 2;
+ WHERE shoe_ready.total_avail >= 2;
</programlisting>
</para>
--
2.55.0