Re: Use uppercase keywords in foreign key tutorial

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>
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
Date: 2025-11-10T04:20:13Z
Lists: pgsql-docs
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



Commits

  1. Doc: more uppercase keywords in SQLs

  2. Doc: use uppercase keywords in SQLs