postgres.git / summary / log / commit / refs
commit 1e8f393f2d037d3821e79349c8fac22ce697e8cd
Author: Fujii Masao <fujii@postgresql.org>
Date: Wed Jul 08 00:04:31 2026 +0000
First released in: 14.24, 15.19, 16.15, 17.11, 18.6
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>
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Daniel Gustafsson <daniel@yesql.se>
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 4aa4e00e017..ce9c93dacff 100644
--- a/doc/src/sgml/rules.sgml
+++ b/doc/src/sgml/rules.sgml
@@ -624,7 +624,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>
[parent: d3888c90a07f]