MIME-Version: 1.0
References: 
 <CAApHDvqR+_EU0mxrmS-AieE_8ovqtmnsJSOk-oq-Rdk3JzNWOg@mail.gmail.com>
 <0a68a965-4599-4af1-a1eb-bd8e1be75788@ewie.name>
 <CAApHDvoqh_K2KTocwWYrGw5vLubnPnTzd1SvYTTonQ=vUXP7Ug@mail.gmail.com>
 <32882add-b671-42db-a041-e2c2c5b7c315@ewie.name>
 <CAApHDvraaZLdTm4XTLkgGhUwecpmNm1dOJMcEToak-Bh5742hQ@mail.gmail.com>
 <4487a138-c4d2-4b06-80b3-5afe7f8e5d82@ewie.name>
 <CAApHDvqSiqmZbdDpZ_JhL5TbXNvKCLt1-Wk5j=4uRPoV0hd9hQ@mail.gmail.com>
 <971a5a3d-c200-4700-824b-f71a6e831994@ewie.name>
 <CAApHDvokYxXGORORfF_uP2PbaF-UagV-m3yySOfjzuqrVmWkCg@mail.gmail.com>
 <CACJufxG5UaQtoYFQKdMCYjpz_5Kggvdgm1gVEW4sNEa_W__FKA@mail.gmail.com>
 <5b870856-1ff9-4776-97ba-f568eb5cbd2f@ewie.name>
In-Reply-To: <5b870856-1ff9-4776-97ba-f568eb5cbd2f@ewie.name>
From: David Rowley <dgrowleyml@gmail.com>
Date: Mon, 10 Nov 2025 17:20:13 +1300
Message-ID: 
 <CAApHDvogerX5Su+M3puBMTdmczr8OAyKF60V7cFPOKvNYOhQ3A@mail.gmail.com>
Subject: Re: Use uppercase keywords in foreign key tutorial
To: Erik Wienhold <ewie@ewie.name>
Cc: jian he <jian.universality@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Bruce Momjian <bruce@momjian.us>, Nathan Bossart <nathandbossart@gmail.com>,
	Euler Taveira <euler@eulerto.com>, pgsql-docs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAApHDvogerX5Su%2BM3puBMTdmczr8OAyKF60V7cFPOKvNYOhQ3A%40mail.gmail.com>
Precedence: bulk

On Mon, 10 Nov 2025 at 16:40, Erik Wienhold <ewie@ewie.name> wrote:
> > in doc/src/sgml/func/func-matching.sgml

> > key word: "similar", "escape", "from", "for" within the above synopsis
> > section need uppercase too?
>
> Thanks, good catch.  Not surprised that I've missed those because it
> already took me a couple of rounds to find everything that's in the
> previous patch.  Here's another patch.

I've pushed this after doing a manual scan the command that the
following outputs:

select 'git grep -E "\b(' || string_agg(word,'|') || ')\("' from
pg_get_keywords();

I didn't see any other ones that are all lowercase. I also tried with
initcap(word). I didn't go as far as writing a regex that searched for
other mixed case but not all upper case.

David