Date: Tue, 28 Oct 2025 16:34:45 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Euler Taveira <euler@eulerto.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Erik Wienhold <ewie@ewie.name>,
	pgsql-docs@lists.postgresql.org
Subject: Re: Use uppercase keywords in foreign key tutorial
Message-ID: <aQE29YG5pY4Cl8ym@nathan>
References: <82eb512b-8ed2-46be-b311-54ffd26978c4@ewie.name>
 <a5034028-3f97-4157-8fd2-6eb552ffaab8@app.fastmail.com>
 <0a9d7393-1cf2-4d38-a648-631c1f93e345@ewie.name>
 <CAApHDvoLfa2UjGfoGfVL4b=g5VbFgscrLONuC3kKE9=VZeeN=Q@mail.gmail.com>
 <b8d76840-5927-40aa-b38e-8ccb685aea92@app.fastmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <b8d76840-5927-40aa-b38e-8ccb685aea92@app.fastmail.com>
Archived-At: <https://www.postgresql.org/message-id/aQE29YG5pY4Cl8ym%40nathan>
Precedence: bulk

I noticed the patch also changes some column types to lowercase:

 <programlisting>
 CREATE TYPE tablefunc_crosstab_N AS (
-    row_name TEXT,
-    category_1 TEXT,
-    category_2 TEXT,
+    row_name text,
+    category_1 text,
+    category_2 text,
         .
         .
         .
-    category_N TEXT
+    category_N text
 );
 </programlisting>

FWIW I tend to use uppercase for those, too, but I'm not sure there is a
preferred style for the docs.

-- 
nathan