MIME-Version: 1.0
References: <178248467618.108999.9966122434342474006@wrigleys.postgresql.org>
 <CAKFQuwZyUsC4jKQ+o3ugVXx4_DgYBKUfX9YZM_1REF7oSqDGkw@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwZyUsC4jKQ+o3ugVXx4_DgYBKUfX9YZM_1REF7oSqDGkw@mail.gmail.com>
From: Fujii Masao <masao.fujii@gmail.com>
Date: Tue, 7 Jul 2026 09:52:39 +0900
Message-ID: 
 <CAHGQGwG5_1Vn7TqreKfrWB8Yx01AqyxJxPoG1HvWMGAK0etZQw@mail.gmail.com>
Subject: Re: Check query
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "y.saburov@gmail.com" <y.saburov@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="00000000000088aa4d0655facf35"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHGQGwG5_1Vn7TqreKfrWB8Yx01AqyxJxPoG1HvWMGAK0etZQw%40mail.gmail.com>
Precedence: bulk

--00000000000088aa4d0655facf35
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, Jun 28, 2026 at 12:51=E2=80=AFAM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Friday, June 26, 2026, PG Doc comments form <noreply@postgresql.org> w=
rote:
>>
>> The following documentation comment has been logged on the website:
>>
>> Page: https://www.postgresql.org/docs/18/rules-views.html
>> Description:
>>
>> ...
>> WHERE shoe_ready.total_avail > 2;  ??? (maybe WHERE shoe_ready.total_ava=
il
>> >=3D 2;)
>
>
> Yes, the lack of an equal sign there is a typo.

Yes. Very old commit dcb00495236 seems to have accidentally changed
the condition to > 2 while rewriting the example to use SQL operator
notation.

The attached patch changes it from > 2 to >=3D 2.
Barring any objections, I'll backpatch it to all supported branches.

Regards,

--=20
Fujii Masao

--00000000000088aa4d0655facf35
Content-Type: application/octet-stream;
	name="v1-0001-doc-Fix-typo-in-rule-system-view-example.patch"
Content-Disposition: attachment;
	filename="v1-0001-doc-Fix-typo-in-rule-system-view-example.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mr9xpfb90>
X-Attachment-Id: f_mr9xpfb90

RnJvbSAzZGE5OTY3MTcyZDA2NjRjZjZhYjQ5ZjRmM2FlZjgxNjFiZDAzMzQ3IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5vcmc+CkRh
dGU6IFR1ZSwgNyBKdWwgMjAyNiAwOTo0NDoyMiArMDkwMApTdWJqZWN0OiBbUEFUQ0ggdjFdIGRv
YzogRml4IHR5cG8gaW4gcnVsZS1zeXN0ZW0gdmlldyBleGFtcGxlCgpDb21taXQgZGNiMDA0OTUy
MzYgYWNjaWRlbnRhbGx5IGNoYW5nZWQgdGhlIGZpbmFsIGV4cGFuZGVkIHF1ZXJ5J3MKY29uZGl0
aW9uIHRvID4gMiB3aGlsZSByZXdyaXRpbmcgdGhlIGV4YW1wbGUgaW50byBTUUwgb3BlcmF0b3Ig
bm90YXRpb24uCgpUaGUgb3JpZ2luYWwgcXVlcnkgYW5kIHRoZSBwcmVjZWRpbmcgcmV3cml0dGVu
IGZvcm1zIGFsbCB1c2UgPj0gMiwKYW5kIHZpZXcgZXhwYW5zaW9uIHNob3VsZCBwcmVzZXJ2ZSB0
aGF0IHF1YWxpZmljYXRpb24uIFRoaXMgY29tbWl0CmNoYW5nZXMgdGhlIGZpbmFsIGNvbmRpdGlv
biBmcm9tID4gMiB0byA+PSAyLgoKQmFja3BhdGNoIHRvIGFsbCBzdXBwb3J0ZWQgdmVyc2lvbnMu
CgpSZXBvcnRlZC1ieTogWWFyb3NsYXYgU2FidXJvdiA8eS5zYWJ1cm92QGdtYWlsLmNvbT4KRGlz
Y3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNzgyNDg0Njc2MTguMTA4OTk5Ljk5NjYxMjI0
MzQzNDI0NzQwMDZAd3JpZ2xleXMucG9zdGdyZXNxbC5vcmcKQmFja3BhdGNoLXRocm91Z2g6IDE0
Ci0tLQogZG9jL3NyYy9zZ21sL3J1bGVzLnNnbWwgfCAyICstCiAxIGZpbGUgY2hhbmdlZCwgMSBp
bnNlcnRpb24oKyksIDEgZGVsZXRpb24oLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcnVs
ZXMuc2dtbCBiL2RvYy9zcmMvc2dtbC9ydWxlcy5zZ21sCmluZGV4IDdmMjM5NjJmNTI0Li45Zjlm
YTk3OGYyZCAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL3J1bGVzLnNnbWwKKysrIGIvZG9jL3Ny
Yy9zZ21sL3J1bGVzLnNnbWwKQEAgLTYzMSw3ICs2MzEsNyBAQCBTRUxFQ1Qgc2hvZV9yZWFkeS5z
aG9lbmFtZSwgc2hvZV9yZWFkeS5zaF9hdmFpbCwKICAgICAgICAgIFdIRVJFIHJzbC5zbF9jb2xv
ciA9IHJzaC5zbGNvbG9yCiAgICAgICAgICAgIEFORCByc2wuc2xfbGVuX2NtICZndDs9IHJzaC5z
bG1pbmxlbl9jbQogICAgICAgICAgICBBTkQgcnNsLnNsX2xlbl9jbSAmbHQ7PSByc2guc2xtYXhs
ZW5fY20pIHNob2VfcmVhZHkKLSBXSEVSRSBzaG9lX3JlYWR5LnRvdGFsX2F2YWlsICZndDsgMjsK
KyBXSEVSRSBzaG9lX3JlYWR5LnRvdGFsX2F2YWlsICZndDs9IDI7CiA8L3Byb2dyYW1saXN0aW5n
PgogICAgPC9wYXJhPgogCi0tIAoyLjU1LjAKCg==
--00000000000088aa4d0655facf35--