Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1vECsI-007JzG-PV
	for pgsql-docs@arkaria.postgresql.org; Wed, 29 Oct 2025 20:34:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1vECsH-003hi2-Oi
	for pgsql-docs@arkaria.postgresql.org; Wed, 29 Oct 2025 20:34:28 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1vECsH-003hht-H0
	for pgsql-docs@lists.postgresql.org; Wed, 29 Oct 2025 20:34:28 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <bruce@momjian.us>)
	id 1vECsE-004wdt-0L
	for pgsql-docs@lists.postgresql.org;
	Wed, 29 Oct 2025 20:34:27 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us;
	s=2025010100; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID:
	Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID:
	Content-Description; bh=/hNfZlwYmcWhpHaDIAm/ewrBBLOmEEmjDCOuz0NyhSY=; b=SI0oU
	2YSWQ6Dp15QwmB3G6IJWQaoASjLIuW7a1NkCBL9oqp3pnmge+4DOX6N2oGFQMlu7uzIL8KYEd9Zwh
	C25W/Xbjisvnx8Mm+dTf7DSrtHVX2KNe33hjAJmQt6iJh9WpZS8xoctAdvmTx+0PCdSWY0fwqdYUZ
	4DtuGJyiFd7R79cnPx5UHZuRRQXdb1969dCDbe6p/+FGOTtLVZDB21+m9O8vePVbdcPTZxRHIsnzC
	y1r1XC2sczGwbLRVwLgrBUmZNrJt1550mb/VikPtupBkQ967eKNsMf0QVJ8QOxNDx6sRCPY/vcCTz
	fxsS047K8f3w0Rbef/HYayumwE6Tg==;
Received: from bruce by momjian.us with local (Exim 4.98.2)
	(envelope-from <bruce@momjian.us>)
	id 1vECsC-00000000UMk-2KF7;
	Wed, 29 Oct 2025 16:34:24 -0400
Date: Wed, 29 Oct 2025 16:34:24 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Euler Taveira <euler@eulerto.com>, 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: <aQJ6UIrQeC6impXg@momjian.us>
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>
 <aQE29YG5pY4Cl8ym@nathan>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <aQE29YG5pY4Cl8ym@nathan>
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/aQJ6UIrQeC6impXg%40momjian.us>
Precedence: bulk

On Tue, Oct 28, 2025 at 04:34:45PM -0500, Nathan Bossart wrote:
> 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.

Agreed, uppercase is better for type names.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.